Kesavan wrote:
> 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.

> 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.,

To quote again: "cannot be done due to limit on joins".

Perhaps another brilliant method is possible, however, this one will not
work.
--
Rik Wasmus