Re: URGENT Join question

Hi Manoj

I'm not certain if it's exactly what you need, but if your problem is "return me all the records from table2 that are not in table1", then this would do it:

select B.col1, B.col2 from table2 B
where not exists
(select A.col1, A.col2 from table1 A
where A.col2 = B.col2
and A.col1 = B.col1);

--
Nicolas Stern