Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Urgent : Data Migration

sriramsriram Member Posts: 14
Hi guyz, I have a situation here. I have a table A and Table B. I want to select the records from table A that are not in table B with a condition that A.field1 <> B.field1 and A.field2 <> B.field2.

Field1 and Field2 are composite keys in both the tables.

if both the table has got Field1 as PK in both the tables, I could have written a query like this.

select * from tableA A where A.field1 not in ( select field1 from Table B)

But here, I need to check if field1 and field2 of table A is not present in Field1 and Field2 of Table B ?

Any help is highly appreciated.
Thanks
Sign In or Register to comment.