Postgres Pro
Downloads
Home   >   mailing lists

How to update an entire table by getting the values from another table? - Mailing list pgsql-novice

From A B
Subject How to update an entire table by getting the values from another table?
Date
Msg-id dbbf25900908310443q510816a1sf2f1d0bd63cc3f29@mail.gmail.com
Whole thread Raw
Responses Re: How to update an entire table by getting the values from another table?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-novice
Tree view 
Hi. I need to run an update query on a table, and need some help on
how to do it.


I have a table A(id integer primary key, prod_id integer, Y1 integer,
Y2 integer, ... Y14 integer)  and a table B (a integer references A, x
integer,unique(a) );

and now I should set (for each row in A)  prod_id to have the value
that is found in table B

How do I write a statement that does that?

pgsql-novice by date:

Previous
From: Ruzsinszky Attila
Date:
Subject: Date interval and bitmask for days - Pl/Perl or SQL
Next
From: "A. Kretschmer"
Date:
Subject: Re: How to update an entire table by getting the values from another table?