RE: [DUG-DB]: Basic SQL Question - UPDATE

[Carl Reynolds]

From memory, isn't it   set (col2, col3, col5) = ((select col2, col3, col4 where ....))   in Informix?  ie, I think you might need two sets of brackets around the select statement?   Cheers, Carl   -----Original Message----- From: Stacey Verner [mailto:[EMAIL PROTECTED]] Sent: Thursday, 24 February 2000 5:29 To: Multiple recipients of list database Subject: RE: [DUG-DB]: Basic SQL Question - UPDATE In Informix we can do   update TblTarget set (col2, col3, col5) = (select col2, col3, col4 where ....) where col1 = ??   I'm not sure if other servers have this syntax.