maqskywalker
asked on
t-sql look for records in two tables
At this link
http://stackoverflow.com/questions/2686254/how-to-select-all-records-from-one-table-that-do-not-exist-in-another-table
I saw this example which selects all records from one table that do not exist in another table.
So it looks for the records in table t1 that do not exist in table t2
SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULL
What's the syntax to look for records in two tables?
So look for the records in table t1 that do not exist in table t2 or table t3 ?
Anyone know?
http://stackoverflow.com/questions/2686254/how-to-select-all-records-from-one-table-that-do-not-exist-in-another-table
I saw this example which selects all records from one table that do not exist in another table.
So it looks for the records in table t1 that do not exist in table t2
SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULL
What's the syntax to look for records in two tables?
So look for the records in table t1 that do not exist in table t2 or table t3 ?
Anyone know?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER