V
VMI
I have two tables, Actual_Employees and Fired_employees (both with the same
fields), and I need to know which custIDs are in both tables AND, of those
with exact CustIDs in both tables, which have the same First_Name and
Last_Name in both tables. So, for example, if there's a record with CustID
"0001", FirstName "Bob", and LastName "Jones" in both tables, this record
should be displayed.
I started with : Select * from Actual_Employees where CustID in (select
CustID from Fired_employees) but I got stuck when checking to see which
records of this resulting group also have the other two conditions (same
First_Name and Last_Name in both tables).
Thanks.
fields), and I need to know which custIDs are in both tables AND, of those
with exact CustIDs in both tables, which have the same First_Name and
Last_Name in both tables. So, for example, if there's a record with CustID
"0001", FirstName "Bob", and LastName "Jones" in both tables, this record
should be displayed.
I started with : Select * from Actual_Employees where CustID in (select
CustID from Fired_employees) but I got stuck when checking to see which
records of this resulting group also have the other two conditions (same
First_Name and Last_Name in both tables).
Thanks.