SQL query - help needed

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.com