|
satya068
Posting Yak Master
USA
230 Posts |
 Posted - 10/09/2012 : 04:27:40
|
Hi,
I have writtend two individual scripts for getting the total num of records
USE RODGER
select count(*) from Action A
inner join Referral R on A.ReferralID = R.ReferralID
where R.EMP_CODE like 'N%' ----520
USE EMP
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?
|
|
SQL join tables
