Hi Dear,

This Code will compare Two Tables.
And Filter Records from Table1 which R not existing in Table2. I think will help out.

SELECT A.COL1,
A.COL2,
A.COL3,
A.COL4
FROM (SELECT COL1,COL2,COL3,COL4 FROM Table1) A
LEFT OUTER JOIN
(SELECT COL1,COL2,COL3,COL4 FROM Table2) B
WHERE (CASE WHEN A.COL1 = B.COL1 THEN 1 ELSE 2 END) = 2

Thanks & Regards

Bhudev Prakash