RE: [SQL] subqueries as values in updates

2000-12-08 Thread Francis Solomon
nal Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: 08 December 2000 13:00 > To: liste SQL > Subject: [SQL] subqueries as values in updates > > > hello, list. > are subqueries alloved as values in an update

[SQL] subqueries as values in updates

2000-12-08 Thread patrick . jacquot
hello, list. are subqueries alloved as values in an update command ? e.g. update a set a.attribute1 = a.attribute1 + (select sum(b.attribute1) from b where b.attribute2=a.attribute2); If yes, how is the correct syntax ? If not, is there a hope for it in a future version ?