Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Re: SQL JOINs vs WHERE statements

by mpeppler (Vicar)
on Aug 18, 2003 at 09:20 UTC ( [id://284507]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://284507]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others contemplating the Monastery: (3)
As of 2024-04-19 20:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found