At 12:40 -0400 7/18/03, John Larsen wrote:
Does anybody know if there is a way to aggregate a table then join
it to another table?
I assume this would be possible with a subquery as in
SELECT * FROM t1 WHERE t1.a=(SELECT sum(t2.b) FROM t2 group by t2.c);
Except when I do it with 4.1alpha I get er
Does anybody know if there is a way to aggregate a table then join it to another table?
I assume this would be possible with a subquery as in
SELECT * FROM t1 WHERE t1.a=(SELECT sum(t2.b) FROM t2 group by t2.c);
Except when I do it with 4.1alpha I get error
"[root] ERROR 1240: Subselect returns mo