Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross on being selected by the Eng-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 %...
