Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL question
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:
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:05:50 CST