I wish to perform a select in which I join two tables. I want to add an extra field telling me for each selected tuple from table 1 - how many tuples from table 2 were joined with it.
as follows:
table 1:
a %
b %
c +
table 2:
a 1
a 3
a 5
a 7
b 2
b 3
c 4
c 5
c 6
desired result:
a % 1 4
a %...