Subject | SQL Select Joins Syntax |
---|---|
Author | Kevin Stanton |
Post date | 2004-03-19T19:03:42Z |
Greetings,
I am currently joining:
select [field list]
from Table1 T1
left outer join Table2 T2 on T1.ID = T2.ID
This gives me everything in Table1 whether or not it exists in Table2.
What is the best way to find out what is in Table2 that is not in Table1.
Thanks,
Kevin
I am currently joining:
select [field list]
from Table1 T1
left outer join Table2 T2 on T1.ID = T2.ID
This gives me everything in Table1 whether or not it exists in Table2.
What is the best way to find out what is in Table2 that is not in Table1.
Thanks,
Kevin