Ingres uses the same kind of syntax as given below, Oracle uses the target column = (nested subquery) syntax. Gives us plenty of scope for fun when porting Ingres to oracle and vice versa.
Which is standard ? Doesn't matter, you have to use the syntax your database(s) support. Mark -----Original Message----- From: Alex Pilosov [mailto:[EMAIL PROTECTED]] Sent: 11 October 2001 05:31 To: Jeff Zucker Cc: dbi-users Subject: Re: [OT] Bulk Updates Using Joins or Some Such Nonsense 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 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. **********************************************************************
