Posting Yak Master
Posted - 10/09/2012 : 04:27:40
I have writtend two individual scripts for getting the total num of records
select count(*) from Action A
inner join Referral R on A.ReferralID = R.ReferralID
where R.EMP_CODE like 'N%' ----520
select count(*) from EMP_PND_WAG
where PND_ACTIONID = 6 --------522
I would like to know those 2 records which are the defference between the tables.
can i know find those 2 records by joining the two tables?