How do you return unlike data between two identical tables.
IE : Table1 , column1,column2,colum3,column4
Table2 , column1,column2,colum3,column4
I need the rows that are not in Table2.
Thanks for the Help
pixel696SELECT a.* FROM myTableA a LEFT JOIN myTableB b
WHERE a.myKey = b.myKey WHERE b.myKey IS NULL
is one way...|||brett, i think you put one too many where clauses. the first one should be replaced with on.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment