View Single Post

   
  #2 (permalink)  
Old 05-07-2008, 10:16 AM
Captain Paralytic
 
Posts: n/a
Default Re: ErrorCode :1116 Limits on join.

On 7 May, 04:57, Kesavan <k7.in...@gmail.com> wrote:
> Hi .,
> When I try to solve a sudoku of 9X9 ., I get a error with this
> message.
>
> Error Code : 1116
> Too many tables; MySQL can only use 61 tables in a join
>
> I need to join more tables [self-join]. The version used is 5.x .
> Is there any remedy to by-pass, or trick?
>
> Help me to find the solution.
>
> Thanks.


I'm so sorry Kesavan, but my crystal ball has broken down. It is not
showing me any of your code or why your design requires so many joins.

Maybe one of the others who hang around this forum has a working
crystal ball.
Reply With Quote