* Arthur Fuller > > I have searched the manual without success. I want to know the maximum > > number of tables MySQL permits to be JOINed in a single SELECT > > statement.
* Roger Baklund > According to crashme, it is 32 in 3.22.39 and 63 in 3.23.39. > > <URL: http://www.mysql.com/information/crash-me.php > * Weaver, Walt > Hmmm... we're running 3.23.47 here and have run into a 32 table join > limit... Yes... that is strange. There could be a bug in the crashme report, or the limit may have been lowered after 3.23.39, but neither of those seems very likely (to me, anyway)... anyone got a clue? -- Roger --------------------------------------------------------------------- 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