I am using SQL Server 2000 as my database. I need a query for the following purpose.
I have two tables Emp and Emp_Name .
Emp Table has fields like Emp_id (integer),DOB(date),PhoneNo(varchar),.......
Emp_Name has fields like Emp_id (integer),lastname,firstname,middlename,.....
I don't have any Primary key and Foreign Key relation ship between these two tables.
I want to get all the Duplicate Employee related records . ie , I want to get employee details who has same first name , last name , middle name and DOB.
Will a single query do the above job ? please give a exact query for the above one.
Thanks In Advance.