I have 2 tables. Table1 and Table2.
I would like to update Table1 with fields from Table2.
So if Table1 Field1 contained May and June,
and Table2 Field2 contained July and September after updating Table1 I would like Field1 to contain May, June, July and September.
Here is what I have been trying with no luck of course.
Code: Select all
'UPDATE Table1 LEFT JOIN Table2 ON Table1.Field1 = Table2.Field1 SET Table1.Field1=Table2.Field1 WHERE Table1.Field1 IS NULL'Any Ideas..
Thanks
Ron