That is the ANSI SQL standard. -----Original Message----- From: Jeff Zucker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 10, 2001 6:20 PM To: dbi-users Subject: Re: [OT] Bulk Updates Using Joins or Some Such Nonsense
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? :-) -- Jeff