Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Re: Re: SQL JOINs vs WHERE statements

by arthas (Hermit)
on Aug 18, 2003 at 08:13 UTC ( #284498=note: print w/replies, xml ) Need Help??


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

Is there perhaps some other kind of consideration like efficiency or speed involved? I'm guessing not.

They should really be the same statement. The only difference is that in the second the join is implicit, but besides the "visual" things nothing else changes.

Michele.

  • Comment on Re: Re: Re: SQL JOINs vs WHERE statements

Replies are listed 'Best First'.
Re: Re: Re: Re: SQL JOINs vs WHERE statements
by Cody Pendant (Prior) on Aug 18, 2003 at 11:17 UTC
    I'm relieved to hear it.

    As those who were putting up with me on the CB today will know, there's something about the JOIN syntax that I just can't get my head around. I'm a very visually-oriented person and I don't have a mental picture that works for me.

    Thank you all for your help.



    ($_='kkvvttuubbooppuuiiffssqqffssmmiibbddllffss') =~y~b-v~a-z~s; print

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://284498]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2019-05-24 06:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you enjoy 3D movies?



    Results (147 votes). Check out past polls.

    Notices?
    • (Sep 10, 2018 at 22:53 UTC) Welcome new users!