[GENERAL] Update from select

2013-05-13 Thread Bret Stern
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

Re: [GENERAL] Update from select

2013-05-13 Thread Igor Neyman
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.

Re: [GENERAL] Update from select

2013-05-13 Thread Justin Tocci
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

Re: [GENERAL] Update from select

2013-05-13 Thread Vincent Veyron
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

Re: [GENERAL] Update from select

2013-05-13 Thread Bret Stern
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

[GENERAL] Update from select??

2003-07-03 Thread jose antonio leo
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

Re: [GENERAL] Update from select??

2003-07-03 Thread Bruno Wolff III
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.