Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
aggregate combined with nonaggregate
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 %...
