How to UPDATE from field in other table

[Eric Berg]

I'm trying to update a field in tableA to a value in a field in tableB based
on a common key.  I get "ERROR 1109: Unknown table 'tableB' in field list"
errors each time.

update tableA 
set somefield=tableB.otherfield 
where tableA.keyfield=tableB.keyfield;

How do I work around this?

-Eric.

-- 
Eric Berg
Chief Technical Officer, iParty Corp.               eberg@stripped
Vice President, New York Linux Users Group           eberg@stripped
work: 212-331-1229                          http://doobie.iparty.com
home: 212-721-2872