SQL question

Hi ALL

I am trying to apply an OUTER JOIN on multiple fields.

Table1: (firstname, lastname)
Table2: (firstname, lastname)

Table2 has all firstnames which is in Table1 Table2 has all lastnames which is in Table1 But Table2 does not have all combination of (firstname, lastname) as Table1 does. For those I would like to have a NULL entry in Table2.

The following is not working

select t2.firstname, t2.lastname
from table1 t1, table2 t2
where t1.firstname = (+)t2.firstname
and t1.lastname = (+)t2.lastname

Any idea? Received on Tue Nov 04 2003 - 09:51:25 CST