A SQL question

[Alex]

Hi everybody

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 these rows 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 comment?

[Jeff]

In article <29ff93bc.0311040706.68478886@posting.google.com>, alexsm@eudoramail.com (Alex) wrote:Hi everybodyI am trying to apply an OUTER JOIN on multiple fields.Table1: (firstname, lastname)Table2: (firstname, lastname)Table2 has all firstnames which is in Table1Table2 has all lastnames which is in Table1But Table2 does not have all combination of (firstname, lastname) asTable1 does. For these rows I would like to have a NULL entry inTable2.The following is not workingselect t2.firstname, t2.lastnamefrom table1 t1, table2 t2where t1.firstname = (+)t2.firstnameand t1.lastname = (+)t2.lastnameAny comment?

Define "not working."

The one thing that stands out to me is that the (+)'s need to follow the
column names, not precede them. Like so:

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