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.

**********************************************************************

Reply via email to