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

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

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 M

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 w

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 s