Re: SQL JOINs vs WHERE statements

My understanding is that the join syntax was a later addition to SQL to disambiguate certain classes of where clause. Not all SQL engines support the syntax. Notably Sybase. (Which I use so im not going to get into further as I dont have the option of the first SQL you posted :-)

---
demerphq

_{<Elian> And I do take a kind of perverse pleasure in having an OO assembly language...}

Comment on Re: SQL JOINs vs WHERE statements Download Code

Replies are listed 'Best First'.
Re: SQL JOINs vs WHERE statements by Abigail-II (Bishop) on Aug 18, 2003 at 09:23 UTC
Not all SQL engines support the syntax. Notably Sybase. page 26 of the quickreference guide for "Adaptive Server Enterprise" seems to think the join syntax is supported. http://download.sybase.com/pdfdocs/asg1250e/quickref_04.pdf Abigail	[reply]
Re: Re: SQL JOINs vs WHERE statements by mpeppler (Vicar) on Aug 18, 2003 at 09:20 UTC
Actually Sybase does support ANSI JOIN clauses (as of ASE 11.x, I think). However, as you I'm more comfortable with implicit joins using the WHERE clause (including using the =* and *= operators for inner/outer joins). Michael	[reply]
Re: Re: Re: SQL JOINs vs WHERE statements by demerphq (Chancellor) on Aug 18, 2003 at 15:58 UTC
(as of ASE 11.x, I think) Im looking at a Sybase 11.5 reference manual right now and I can't find it at all. And yes, im much more used to using = and = instead. That verbose join syntax always kinda gets me... :-) But it is nice to know its available in 12.5 --- demerphq _{<Elian> And I do take a kind of perverse pleasure in having an OO assembly language...}	[reply] [d/l]
Re: Re: Re: Re: SQL JOINs vs WHERE statements by mpeppler (Vicar) on Aug 18, 2003 at 16:20 UTC
Ah - I guess it was in 12.0 (or maybe 11.9.2). Thanks for the correction. Michael	[reply]