Urgent : Data Migration

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.

Howdy, Stranger!

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

Categories