> Is there a document that compiles examples on different ways of joining > two or more tables? I found a few on > http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more > than two tables. > > Thanks for any suggestions.
I wish there were more examples as well! I use this for multi-table joins: SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id INNER JOIN table3 ON table3.some_id WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id; Not sure if this the best way or not, but it works... Anyone with more experience care to contribute? Are there optimum ways to join multiple tables? Josh --------------------------------------------------------------------- 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
