I have two separate tables which have many common fields. One such field is called [contact number].
I want to update table1 with all of the information from table2 where the [contact number] field is not the same i.e. exclude data where there is a match.
I have tried to do this, but am either: 1) too inexperienced (I'm not a developer, just a lowly marketing person), 2) too tired (it's been a long, rough day) or 3) too stupid (blame the parents... I'm a product of their joint gene pool!)
k... I assume once you do this, you will only use one table... right?
INSERT INTO tbl1 (your, field, list, here)
SELECT tbl2.your, tbl2.field, tbl2.list, tbl2.here
FROM tbl2 LEFT JOIN tbl1 ON tbl2.[control number] = tbl1.[control number]
WHERE tbl1.[control number] IS NULL;