From: Christian Mack
Date: March 31 1999 5:22pm
Subject: Re: How to UPDATE from field in other table
List-Archive: http://lists.mysql.com/mysql/1246
Message-Id: <370259CF.1CB5CD1F@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Eric Berg wrote:
>
> 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.
Hi Eric
The above is illegal SQL, because UPDATE uses only one table.
Try the REPLACE ... SELECT ... syntax.
Tschau
Christian