On Sat, 27 Mar 2004 15:50:25 +0000 (UTC), Alois Maier wrote:

> ...
> Right, a "WHERE Table.field2=table2.field2" was missing.
> I definitely did not want to join everything. I was not interested in
> the cartesian product.

Consider using the 'explicit join' style:
select ...
from TABLE1 T1 join TABLE2 on T1.FIELD1 = T2.FIELD2
group by ...
with selection criteria only in the WHERE clause.


--
Aage J.