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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.