On Sunday 09 September 2001 20:17, Armando Cerna wrote:
> Hi I am trying to update a table that is full of customer ID's using
> another table with the following command
>
> update customers set row_id=mc.id where tele=mc.tele;
>
> But it give me the error
>
> ERROR 1109: Unknown table 'mc' in wh
Hi I am trying to update a table that is full of customer ID's using another
table with the following command
update customers set row_id=mc.id where tele=mc.tele;
But it give me the error
ERROR 1109: Unknown table 'mc' in where clause
The table mc does exist I am pretty lost on this one an
