I need to update the fields in "survey_data" from the values in "bld1".
Both tables have a field called "SEQ", "NOR","SOU", etc.
I tried the following in MySql
survey_data.NOR = bld1.NOR,
survey_data.SOU = bld1.SOU,
survey_data.EAS = bld1.EAS,
survey_data.WES = bld1.WES
INNER JOIN bld1 on survey_data.SEQ = bld1.SEQ
I get this error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM bld1
INNER JOIN bld1 on survey_data.SEQ = bld1.SEQ' at line 7
What did I miss?