View Single Post

  #4 (permalink)  
Old 05-07-2008
Rik Wasmus
 
Posts: n/a
Default Re: ErrorCode :1116 Limits on join.

On Wed, 07 May 2008 06:57:52 +0200, Kesavan <k7.india@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.


Everything you want to know about Sudoku's & MySQL:
http://www.futhark.ch/upload/The_Los...lf_Join.tar.gz

"can't be done due to limit of joins"

A 6*6 is perfectly possible though.
--
Rik Wasmus
Reply With Quote