Re: Table name specified more than once

On Fri, 13 Jun 2003 17:07:28 +0200, Alexander Mueller
<Alexander(dot)Mueller(at)SurfControl(dot)com> wrote:
>It results in a "Table name "Workstations" specified more than once" error
>message. Can anyone help me with correcting the syntax?

Don't include the table you want to update in the FROM list:

UPDATE onetable
SET col1 = othertable.cola, col2 = othertable.colb
FROM othertable
WHERE onetable.x = othertable.y;

In your case othertable is the subselect and the JOIN condition moves
to the WHERE clause.

>copying, distribution or any action taken or omitted to be taken in
>reliance on it, is prohibited and may be unlawful.

Am I going to be arrested? :-(

Servus
Manfred