http://qs1969.pair.com?node_id=284498


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.

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