OK. Here's the source. This is cut and pasted in from MS's Sql books Online (The books that are installed with their product). I do not have the actual standard so I have to trust their documentation. This is from the "From" subsection of the UPDATE section:
<pasted> The FROM clause supports the SQL-92-SQL syntax for joined tables and derived tables. SQL-92 syntax provides the INNER, LEFT OUTER, RIGHT OUTER, and FULL OUTER join operators. </pasted> That is what I used for my basis for claiming it to be "Standard syntax". Steve H. -----Original Message----- From: Jeff Zucker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 10, 2001 10:39 PM To: dbi-users Subject: Re: [OT] Bulk Updates Using Joins or Some Such Nonsense Alex Pilosov wrote: > > On Wed, 10 Oct 2001, Jeff Zucker wrote: > > > Steve Howard wrote: > > > > > > The Standard SQL syntax for updating based on a join is this > > > > > > UPDATE Table1 > > > Set Column1 = r.Column1, Column2 = r.Column2 > > > FROM Table1 l INNER JOIN Table2 r ON l.Column3 = r.Column3 > > > > In which standard is that standard syntax? :-) > > ANSI SQL3, Possibly, but not in any sources I've seen. Could you provide me a cite? (Not for pedantic purposes or because I'm "challenging" you, but because I'd like to know the source). > maybe even SQL2. Definitely not. See my reply to Steve. -- Jeff