Thread: Need help with update

Hello.
My SQL is a little rusty,

With these tables (where id is unique)

Table Y:
 a  | id
----+---
 10 | 1
 20 | 2
 30 | 3

Table X:

 a | id
---+---
 1 | 1
 2 | 2
 3 | 3

Now I want to update each row in the Y table and set the a value to
the corresponding a value that is found in the X table, matched on the
id.

This means  that in the end, the Y table should contain the same
values as the X table in this case.

But how do I write a command to do that?

In response to A B :
> Hello.
> My SQL is a little rusty,
>
> With these tables (where id is unique)
>
> Table Y:
>  a  | id
> ----+---
>  10 | 1
>  20 | 2
>  30 | 3
>
> Table X:
>
>  a | id
> ---+---
>  1 | 1
>  2 | 2
>  3 | 3
>
> Now I want to update each row in the Y table and set the a value to
> the corresponding a value that is found in the X table, matched on the
> id.
>
> This means  that in the end, the Y table should contain the same
> values as the X table in this case.

update y set a=x.a from x where y.id=x.id;


HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99