Re: How to UPDATE from field in other table

[Christian Mack]

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