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 > www.workflowproducts.com > 7813 Harwood Road > North Richland Hills, TX 76180 > phone 817-503-9545 > skype justintocci > > On May 13, 2013, at 3:23 PM, Bret Stern <bret_stern@xxxxxxxxxxxxxxxxxxxxx> wrote: > > > 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 employees SET sales_count = sales_count + 1 WHERE id = > > (SELECT sales_person FROM accounts WHERE name = 'Acme Corporation'); > > > > > > Many thanks > > > > Bret Stern > > > > > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
