multiple column update / Sybase

[Brusk Baran]

Salut comrades,
I have to make a complicated updated to a temporary table, which will be nourished with data from around 5 tables.(db= Sybase 12.5)

 
update #temp_table
set (col1, col2, ...., colN)     (with or w/o = tried)[B]=[/B]
select distinct
  t1.c1,
  t2.fname,
  max(case when t3.price = 'P' then t3.bilanz else 0 end) initialprice,
  ....
where
   ...... 

whatever i've tried, get always errors warning about Incorrect syntax near '('. seems that I MUST update the columns one by one.. is it so?
regards,
[ November 26, 2003: Message edited by: Brusk Baran ]
[ November 26, 2003: Message edited by: Brusk Baran ]

[Brusk Baran]

It seems that a simultaneous multiple column update to a table is not possible. Instead one by one....
create index ...... with ignore_dup_key is also very helpful.. to insert new rows without thinking of duplications, they are ignored implicitly.
This was helpful in my problem.