Unmatched records in Oracle 10g

I need tbl1 and tbl2 in oracle 10g. I have field1 and field2 in both table. I need a sql stmt which will give me all the records in tbl1 without matching records in tbl2 base on field1&field2.

thanks in advance
Who is Participating?
mrongConnect With a Mentor Author Commented:
here it is
SELECT Table1.*
FROM Table1 LEFT JOIN table2 ON
(table1.[fielda] = table2.[fielda]
table1.[fielda] = table2.[fielda]
and etc...
WHERE (((table2.[fielda]) Is Null));
Naveen KumarProduction Manager / Application Support ManagerCommented:
try the below :

FROM Table1 a
where not exists ( select 1 from table2 b where b.fielda = a.fielda and b.fieldb=a.fieldb );
Guy Hengel [angelIII / a3]Billing EngineerCommented:
mrong: your query is already fine, the code of nav_kum_v should work exactly the same.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.