Re: Help: update multiply columns in table

Posted in 1995

Vadim J. Nikitin — 29 Aug 1995 14:06:14 GMT — source: Informix-list mailing list archive (1991-1998)

tangh@cc.memphis.edu wrote: : update result_table : set(col2) = (select col1 from temp_table where city='DAL') : where temp_table.halfhr = result_table.halfhr You must write SET col2 = (SELECT col1 ...) or SET (col2) = ((SELECT col1 ...))