RE: Join syntaxes not all defined
The manual's description of Join Syntax lists the various kinds of syntax but doesn't define some of them, e.g.: table_reference, table_reference and table_reference INNER JOIN table_reference join_condition Yes, it does. I'm guessing these two are equivalent, except that you can't use a join_condition with the first form. Could someone please confirm? section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join syntaxes not all defined
section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... Carsten H. Pedersen ?? Since this does not appear in the manual for v. 3.23.42, which I'd been using, I just downloaded the current one from http://www.mysql.com/documentation/index.html . For some reason, the manual I got is for version 4.0.0-alpha. Can someone explain why that webpage doesn't offer the manual for the lastest stable release? Still more puzzling is that the above excerpt about INNER JOIN does not appear in this alpha version manual either. Where does it come from? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Join syntaxes not all defined
section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... Carsten H. Pedersen ?? Since this does not appear in the manual for v. 3.23.42, which I'd been using, I just downloaded the current one from http://www.mysql.com/documentation/index.html . For some reason, the manual I got is for version 4.0.0-alpha. Can someone explain why that webpage doesn't offer the manual for the lastest stable release? Still more puzzling is that the above excerpt about INNER JOIN does not appear in this alpha version manual either. Where does it come from? The manual for v. 3.23.41. You're right: It seems to have been left out in the current version. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php