in reply to Re: SQL JOINs vs WHERE statements
in thread SQL JOINs vs WHERE statements

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

Replies are listed 'Best First'.
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]
      Ah - I guess it was in 12.0 (or maybe 11.9.2). Thanks for the correction.

      Michael

[reply]

In Section Seekers of Perl Wisdom