List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:April 27 1999 8:58am
Subject:No. of tables in JOIN
View as plain text  
>>>>> "Peter" == Peter WR <pwr@stripped> writes:

Peter> Hi,
Peter> Is there any MySQL limitations to number of different tables in a JOIN
Peter> statement ?

Peter> There might be some practical, but that's another issue.

The internal limit is 32 (as shown in  This limit may be increased to 
64 by changing one typedef.

No. of tables in JOINPeter WR27 Apr
  • No. of tables in JOINMichael Widenius27 Apr