NYCPHP Meetup

[Adrian Noland]

On 7/23/07, Rob Marscher <rmarscher at beaffinitive.com> wrote:
>
>
> If you did an INNER JOIN:
> SELECT u.id, s.id FROM user u INNER JOIN session s ON u.id =
> s.user_id WHERE u.id = 5

<snip>

>
> ...  We had a discussion last year
> on NYPHP-MySQL about INNER JOIN versus commas (cartesian join) -- you
> so often see it with commas in tutorials and other people's code.
> But the concensus we came to was that it's best to be as specific as
> possible... so I've always used INNER JOINs instead of commas ever
> since.
>
> Later,
> Rob
>

Rob,
Is INNER JOIN synonymous with JOIN ON? Does one imply the other?

And do you remember the time frame of that discussion to look it up?
Thanks,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070724/7eaa78c3/attachment.html>