I have a SSN in Table1 and SSN, NAME in Table2. I want to retrieve the matched SSN's from both Tables and NAME from Table2 for the same record set.
SELECT Table1.SSN, Table2.Name FROM Table1 INNER JOIN Table2 ON Table1.SSN = Table2.SSN
Go to http://www.w3schools.com/sql and look at joins.
Sorry!Sorry...<BR><BR>I need to find out the Un Matched SSN's and i need to display the Un Matched SSN with Name from Table2....
SELECT Table2.SSN, Table2.Name FROM Table2 WHERE NOT EXISTS (SELECT Table1.SSN FROM Table1 WHERE Table1.SSN = Table2.SSN)