From: Eric Berg
Date: March 31 1999 3:39pm
Subject: How to UPDATE from field in other table
List-Archive: http://lists.mysql.com/mysql/1242
Message-Id: <14082.16843.738076.495343@doobie.spacelab.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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