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)
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 ]
Joined: Nov 15, 2001
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.