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
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.