At 3:46 pm +0000 7/2/06, [EMAIL PROTECTED] wrote: >Yes, you can do multi-way joins, and people often do. My biggest is 3-way, but >some people do at least 5-way.
My record is and 8-way join (7 tables, one twice). So there! ;-) >Beware that it is easy to specify operations which will heavily load the >system if you are not careful. Yes indeed. You need to think carefully about what indices you need on your tables. As has already been said, EXPLAIN SELECT is your friend! James Harvard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
