SQL question

From: Alex <alexsm_at_eudoramail.com>
Date: 4 Nov 2003 13:25:04 -0800
Message-ID: <29ff93bc.0311041325.bcc6111@posting.google.com>

Hi ALL

I've two tables and am trying to apply an OUTER JOIN on multiple fields.

Table A has some rows as:

<Table A>

--- ---
 1 a
 1 b
 2 b
 3 a
 3 c

Table B is missing some of the rows.

<Table B>

--- ---
 1 a
 2 b
 3 c

Looking for only those rows Table B is missing:

---

1 b NULL
3 a NULL

The following is not working:

select t1.number, t1.letter, t2.number, t2.letter from TableA t1, TableB t2
where t1.number = (+)t2.number
and t1.letter = (+)t2.letter Received on Tue Nov 04 2003 - 15:25:04 CST