On May 7, 2:51 pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> On Wed, 07 May 2008 06:57:52 +0200, 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.
>
> 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

Hi Wasmus.,
This query is generated from that The_Lost_Art_of_the_Self_Join. I
test it for 6x6 .Good.,
But I need to test the same for 9*9.

Help me.,