[SOLVED] Unknown table problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
voltrader
Forum Contributor
Posts: 223
Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area

[SOLVED] Unknown table problem

Post 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?
User avatar
voltrader
Forum Contributor
Posts: 223
Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area

Post by voltrader »

Doh... figured it out -- I should've referenced table cross in the first part of the update clause.

SOLVED
Post Reply