Hi all,
I have two similar tables CUST and CUST_TEMP, and they are both supposed to have the same data and when I am looking at the counts CUST_TEMP if off by 100+ records.
The primary key is CUST_ID (INT (4)) and ASSET ( CHAR(80)) .
Is there a way to find the missing records in CUST_TEMP table?

Thanks in advance..

select * from cust a where not exists
(select t.CUST_ID ,t.ASSET
from cust_temp t
where
t.CUST_ID=a.cust_id and
t.ASSET =a.asset)