Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> trouble with joins
I have two tables, table A has 62 rows table B has 1, (but could be more), both share a common column.
I want my query to show a sum of all of the rows in table A, and the sum of the row or rows in table B on the same row.
The join column is neither of these columns, but is my "group by" column.
whats the best way to do this?
Sent via Deja.com
http://www.deja.com/
Received on Mon Jan 08 2001 - 17:36:07 CST