Help with SQL
Help with SQL
(OP)
Hi,
I have two tables (table1 and table2). They both contain two fields (ID and state). What I would like is to list all the ID's in table1 that are either not in table2 or if the ID is in table2 to see if the state in table1 is not in table2 with matching ID's.
For example in table1 you have an ID of 1234 and a state of IL. In table2 if 1234 is not there to list it or if 1234 is in table2 and table2 has 1234 IN, 1234 OK, 1234 OR to list the ID because it does not have 1234 IL.
I have tried several different ways with not luck. Could someone please help me out.
Thanks,
Mark
I have two tables (table1 and table2). They both contain two fields (ID and state). What I would like is to list all the ID's in table1 that are either not in table2 or if the ID is in table2 to see if the state in table1 is not in table2 with matching ID's.
For example in table1 you have an ID of 1234 and a state of IL. In table2 if 1234 is not there to list it or if 1234 is in table2 and table2 has 1234 IN, 1234 OK, 1234 OR to list the ID because it does not have 1234 IL.
I have tried several different ways with not luck. Could someone please help me out.
Thanks,
Mark
Talk To Other Members
RE: Help with SQL
FROM table1 T1 LEFT JOIN table2 T2
ON T1.ID = T2.ID AND T1.state = T2.state
WHERE T2.ID IS NULL
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Help with SQL
FROM table1 T1 LEFT JOIN table2 T2
ON T1.ID = T2.ID
WHERE COALESCE(T2.state,') <> T1.state
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon