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

You can't have that many joins. No bypasses and no tricks. Sorry.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================