Finding Diferences from two different tables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Finding Diferences from two different tables

Author

Topic

osirisa
Constraint Violating Yak Guru

289 Posts

Posted - 2011-03-14 : 13:06:32

Good Morning Group:

I need to find the differences on an Employee Number field from two tables. Here is an example of my query.

SELECT  dbo.Employee_Number, dbo.DR_GSP_Employee.Full_Name,  
FROM         dbo.DR_GSP_Employee LEFT OUTER JOIN
                      dbo.GSP_LDAP_data ON dbo.DR_GSP_Employee.GSP_Employee_Number <> dbo.GSP_LDAP_data.employeeNumber
ORDER BY dbo.DR_GSP_Employee.Full_Name

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2011-03-14 : 13:27:42

SELECT dbo.Employee_Number, dbo.DR_GSP_Employee.Full_Name
FROM dbo.DR_GSP_Employee
LEFT OUTER JOIN dbo.GSP_LDAP_data ON dbo.DR_GSP_Employee.GSP_Employee_Number <> dbo.GSP_LDAP_data.employeeNumber
Where GSP_LDAP_data.employeeNumber is null
ORDER BY dbo.DR_GSP_Employee.Full_Name

Cheers
MIK

osirisa
Constraint Violating Yak Guru

289 Posts

Posted - 2011-03-14 : 13:47:43

Hi MIK:

Thank you but that query is not quite working. Thanks,

GhantaBro
Posting Yak Master

215 Posts

Posted - 2011-03-14 : 14:00:14

quote:
Originally posted by MIK_2008

SELECT dbo.Employee_Number, dbo.DR_GSP_Employee.Full_Name
FROM dbo.DR_GSP_Employee
LEFT OUTER JOIN dbo.GSP_LDAP_data ON dbo.DR_GSP_Employee.GSP_Employee_Number <> dbo.GSP_LDAP_data.employeeNumber
Where GSP_LDAP_data.employeeNumber is null
ORDER BY dbo.DR_GSP_Employee.Full_Name

Cheers
MIK

It should be

FROM dbo.DR_GSP_Employee
LEFT OUTER JOIN dbo.GSP_LDAP_data ON dbo.DR_GSP_Employee.GSP_Employee_Number = dbo.GSP_LDAP_data.employeeNumber
Where GSP_LDAP_data.employeeNumber is null
ORDER BY dbo.DR_GSP_Employee.Full_Name

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources