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, maybe even SQL2.
-alex