Re: Update from select

> 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


Your question isn't very clear.
Are you updating all records in tbl1? 
Or col1 in tbl1 should also match col1 in tbl2?

If that's the case:

UPDATE tbl1 t1 
  SET col3 = t2.col3, col4 = t2.col4, col5 = t2.col5
  FROM tbl2 t2
  WHERE t1.col1 = t2.col1
    AND t.col1 = "criteria";

Igor Neyman