Error message is:
Unknown column 'expireds.Site_Address' in 'where clause'
Am getting this error when executing the following procedure, can't figure out where I'm messing up. DB Mgr (SQL Mgr 2010) is finding the columns (once I type in the table name, a list of columns pops up, and I'm able to select the columns by clicking on them):
INSERT IGNORE INTO expireds (Parcel_Number, Comments)
SELECT `Oc Phn`, `Showing Instructions`
WHERE actives.`Address`= expireds.`Site_Address`
the problem here is that your INSERT statement is not correct. It appears you are referencing back to a field in the table you are inserting into.
If you explain what you are trying to achieve? I think you are looking to is to UPDATE the expireds parcel number and comments from the entries that exist in the actives table based on the site address field.
If that is the case then you will need to run the following query:
JOIN actives ON (actives.`Address`= expireds.`Site_Address`)
SET Parcel_Number = `Oc Phn`, Comments = `Showing Instructions`;