Code: Select all
UPDATE new_table SET ID = cross.CatID WHERE cross.PlaceID = new_table.PlaceID#1109 - Unknown table 'cross' in where clause
I know that the table cross exists -- what else could be the problem?
Moderator: General Moderators
Code: Select all
UPDATE new_table SET ID = cross.CatID WHERE cross.PlaceID = new_table.PlaceID