Re: Request: Support for __JOIN(c1.fkey c2)__

[prev] [thread] [next] [Date index for 2005/05/04]

--mP3DRpeJDSE+ciuQ
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, May 04, 2005 at 09:35:47PM +0100, Tony Bowden wrote:
> On Wed, May 04, 2005 at 11:59:52AM -0700, Randal L. Schwartz wrote:
> > And while you're in there dinkin' with that code, some support for
> > various joins in the FROM section would be nice too.
> > I'm slowly coming around to the notion that all joins should be listed
> > in FROM, reserving WHERE for strictly things that are reducing the
> > table set.  If I'm missing something, let me know.
>=20
> How compatible is that?=20
>=20
> I have a notion that that's in SQL <handwave> rather than SQL
> <handwave>, and that not everything supports it. But I don't really
> know any of that sort of stuff well enough, and haven't the time to go
> digging at this point...

It's SQL92 I think. And I'd be surprised if there were any major SQL
implementations that don't support it.

Dave...

--=20
  This is the definition of my life

--mP3DRpeJDSE+ciuQ
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFCeUZDhlYrNpFq+8ERAjkGAJ4gUDLhqwe2vTu0dIGqDl/AxpWl3wCdEg9y
PwKDKZO2U4ov/RB0OrF0mBI=
=Obe4
-----END PGP SIGNATURE-----

--mP3DRpeJDSE+ciuQ--