On 7/23/07, Rob Marscher <[EMAIL PROTECTED]> 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,
_______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
