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.
Showing posts with label column4. Show all posts
Showing posts with label column4. Show all posts
Friday, March 9, 2012
Subscribe to:
Posts (Atom)