aggregate combined with nonaggregate
aggregate combined with nonaggregate
(OP)
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 % 3 4
a % 5 4
a % 7 4
b % 2 2
b % 3 2
c + 4 3
c + 5 3
c + 6 3
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 % 3 4
a % 5 4
a % 7 4
b % 2 2
b % 3 2
c + 4 3
c + 5 3
c + 6 3
Talk To Other Members
RE: aggregate combined with nonaggregate
RE: aggregate combined with nonaggregate
f1 is field1 from tabl1
f2 is field2 from tabl1
f11 is field1 from tabl2
f22 is field2 from tabl2