Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL help, Please???
I have 2 Oracle 7 views I need to combine with a select statement.
The first has 100,000 + records with a unique key. The second has multiple records ( or none ) on the same key.
I need left join(?) syntax which will allow me to get all of the multiple records in the second file attached to each of the unique records in the first file, always having the same total number of fields in each row of the result set.
Any ideas?
-- Lynn C. Ormond Lucero Research Reply to: Lynn_at_Lucero.comReceived on Tue Apr 24 2001 - 16:28:17 CDT