On Wed, 10 Oct 2001, Jeff Zucker wrote: > 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). I may be mistaken. I really do not know for sure whether this is SQL3, unfortunately, neither of us can find out since blessed standard costs 305$ for copy, and the latest draft I have is from '95 :(
-alex