Re: brain dead sql syntax help update stmt

Posted in 2001

Sharok — Fri, 26 Jan 2001 18:34:56 +0100 — source: Informix-list mailing list archive (1991-1998)

Are you sure that column names aren't reserved words!! Sharok You haven't got columns called with Doug Fossmeyer <dfossmeyer@gmx.net> wrote in message news:94qhan$49k$1@news.xmission.com... > > Ok, I am brain dead and this does not work: > > update t1 set (col1, col2, col3, col4) = ((select col1, col2, col3, col4 > from t2 where t1.id = t2.id and t2.col5 = "PM"));> > > > All I get is a "syntax error" and I need someone's help. Actual solution is > wonderful and the explanation is bonus points. > > tia > > Doug >