Update multiple fields with select

What is the best way to update a table with multiple values from another table, such as :

update my_tab1 set
  f1 = (select xyz from my_tab2 where my_tab1.pk=my_tab2.pk),  (f2,f3) = select (foo,bar from my_tab3 where my_tab1.pk=my_tab3.pk) where my_tab1.fldx='Anything'

I looked at the documentation, but it is not very clear to me.

Any tips ?

Ted
EMail: knijff_at_bigfoot.com Received on Mon May 14 2001 - 12:08:46 CDT