I have three tables.
This is the pseudo code of what I want to do with the tables.
If FirstName and LastName exists in payroll_current AND exists in
payroll_terminated then do NOT show record in nds_all
Constraints are that the data from our Novell NDS tree does not have a
unique identifier like the emp no field that exists in the payroll tables. I
am trying to use the FirstName and LastName fields to create the joins but
have not been successful.
Any help appreciated (I hope this formats ok for everyone.)
Any help greatly appreciated
nds_all ID Context UserID FirstName Surname LastLoginTime GWUserID
16 xxx.mhs xxxx xxxxx xxxx 30/06/2000 1:35:45 AM
17 xxx.mhs xxx xxx xxxxx 8/02/2002 5:04:10 AM
18 xxx.mhs xxxx xxxx xxxx 15/10/2003 10:37:25 PM SABEY
19 xxx.mhs xxxx
20 xxxx.mhs xxxx xxxx xxxx 30/04/2002 10:33:45 PM
payroll-current Emp No Location Name Hired Surname FirstName SecondName
xxxx xxx xxxx 31/08/1987 xxxx xxxx xxxx
xxxx xxx xxxx 31/10/1989 xxxx xxxx xxxx
payroll_terminated Emp No Location Name Hired Terminated Surname FirstName
A229 xxxxx xxxx 25/06/2001 25/06/2002 xxxx xxxx xxxx xxxx
A240 xxxx xxxx 18/02/2002 28/07/2002 xxxx xxxx xxxx
A245 xxxx xxx 26/05/2002 25/08/2002 xxxx xxxx