Page 1 of 1

[SOLVED] Unknown table problem

Posted: Fri Sep 09, 2005 1:24 pm
by voltrader

Code: Select all

UPDATE new_table SET ID = cross.CatID WHERE cross.PlaceID = new_table.PlaceID
I receive this error when running the MySQL code above:
#1109 - Unknown table 'cross' in where clause

I know that the table cross exists -- what else could be the problem?

Posted: Fri Sep 09, 2005 1:38 pm
by voltrader
Doh... figured it out -- I should've referenced table cross in the first part of the update clause.

SOLVED