SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL join tables
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

satya068
Posting Yak Master

USA
230 Posts

Posted - 10/09/2012 :  04:27:40  Show Profile  Reply with Quote
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?

webfred
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 10/09/2012 :  04:32:12  Show Profile  Visit webfred's Homepage  Reply with Quote
We don't know the relation between the tables so it is not possible to give a solution.


Too old to Rock'n'Roll too young to die.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000