Need help with update - Mailing list pgsql-novice

From A B
Subject Need help with update
Date
Msg-id dbbf25901002240109j13d987adn6bd7e0c507db5928@mail.gmail.com
Whole thread Raw
Responses Re: Need help with update
List pgsql-novice
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?

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Seeking experiences 'accessing' Microsoft Active Directory credentials from PostgreSQL, in conjunction with the sys admin / IT...
Next
From: "A. Kretschmer"
Date:
Subject: Re: Need help with update