PG 8.4
Having trouble putting together an update query to update
multiple columns in tbl1 from columns in tbl2.
update tbl1
set col3,col4,col5
from
(select col3, col4,col5 from tbl2 where col1=criteria)
Can someone add to the Postgres Docs (shown below) to help me with this.
UPDATE
PG 8.4
Having trouble putting together an update query to update multiple
columns in tbl1 from columns in tbl2.
update tbl1
set col3,col4,col5
from
(select col3, col4,col5 from tbl2 where col1=criteria)
Can someone add to the Postgres Docs (shown below) to help me with
this.
em stands for easy money
update tbl1
set col3=em.col3,col4=em.col4,col5=em.col5
from
(select col3, col4,col5 from tbl2 where col1=criteria) em
Regards,
Justin Tocci
Programmer
www.workflowproducts.com
7813 Harwood Road
North Richland Hills, TX 76180
phone 817-503-9545
skype justintocci
On May
Le lundi 13 mai 2013 à 13:23 -0700, Bret Stern a écrit :
PG 8.4
Having trouble putting together an update query to update
multiple columns in tbl1 from columns in tbl2.
update tbl1
set col3,col4,col5
from
(select col3, col4,col5 from tbl2 where col1=criteria)
UPDATE tbl1
SET
Easy money indeed. Thanks for the help
On Mon, 2013-05-13 at 15:28 -0500, Justin Tocci wrote:
em stands for easy money
update tbl1
set col3=em.col3,col4=em.col4,col5=em.col5
from
(select col3, col4,col5 from tbl2 where col1=criteria) em
Regards,
Justin Tocci
Programmer
Hi all,
I need do a update from t1 set col='P' where int_art = (SELECT int_art from
t2 ).
I know that thios sentence is not correct but I'd like do the update for
everethigs rows that return the select.
Is it posible?
Tk very much
Jose Antonio
-Mensaje original-
De: [EMAIL
On Thu, Jul 03, 2003 at 20:37:27 +0200,
jose antonio leo [EMAIL PROTECTED] wrote:
Hi all,
I need do a update from t1 set col='P' where int_art = (SELECT int_art from
t2 ).
I know that thios sentence is not correct but I'd like do the update for
everethigs rows that return the select.