I have two sql servers,
SQLA is SQL 2000 with a database named CLUB containing tables: CustomerFirstName CardID CustomerLastName
SQLB is SQL2005 with a database named HOTEL containing tables: CustomerFirstName, CARDNUMBER and CustomerLastName
The goal is to determine what customers from SQLB have used our services contained in SQLA. By matching on any of the tables, we need to idenitfy which customers from SQLB also have a CardID in SQLA and which do not. We also need to match by name, those who do have a CARDNUMBER but have a blank CardID entry. These tables will not be equal length. These servers are linked.
Can this be done?