Quote:
Originally Posted by psili
UPDATE TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.COLUMN_1= TABLE_2.COLUMN_2
SET TABLE_1.COLUMN = EXPR WHERE TABLE_2.COLUMN2 IS NULL
Sorry. Just lazy and posting from MySQL docs.
|
THANK YOU SO MUCH!
I suck at mysql this was taking me forever. I know a few guys that know way more then me and they couldn't do it either.
Big thanks!