Type error in my post, should be:
UPDATE table1
SET table1.x = table2.x
WHERE table1.id = table2.id;
--
Greets,
Adam
-------------------------------------------
Adam Boczek
IT Consultant
GFT Solutions GmbH
adam.boczek_at_gft-solutions.de
-------------------------------------------
"Adam Boczek" <adam.boczek_at_NO_SPAM_gft-solutions.de> schrieb im Newsbeitrag
news:998905644.129215_at_tux2.ham.acs-gmbh.de...
> I have two tables:
> table1 with fields "id" and "x"
> table2 with fields "id" and "x"
>
> I'd like to update value of field "x" from table1 with value of field "x"
> from table2 where "id" of table1 = "id" od table2. I've try this
statement:
>
> UPDATE table1
> SET table1.x = table2.x
> WHERE table1.id = table.id;
>
> but I always receive error that the name of feld is not correct. How can
> write such easy statement? In Access I've used "left join" and so on
without
> any problems...
> Help
>
> Greets,
> Adam
>
> -------------------------------------------
> Adam Boczek
> IT Consultant
> GFT Solutions GmbH
> adam.boczek_at_gft-solutions.de
> -------------------------------------------
>
>
>
Received on Mon Aug 27 2001 - 04:49:40 CDT
