SQL question

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:

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 - 22:24:10 CET