ErrorCode :1116 Limits on join.

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.

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.

Hi Captain.,
Please note this is my query for a sudoku of 9x9 's solution,
When I try this , i get the error.,

SELECT CONCAT(
d11.d, ' ', d12.d, ' ', d13.d, ' ', d14.d, ' ', d15.d,
' ', d16.d, ' ', d17.d, ' ', d18.d, ' ', d19.d, ' ', '\n',
d21.d, ' ', d22.d, ' ', d23.d, ' ', d24.d, ' ', d25.d,
' ', d26.d, ' ', d27.d, ' ', d28.d, ' ', d29.d, ' ', '\n',
d31.d, ' ', d32.d, ' ', d33.d, ' ', d34.d, ' ', d35.d,
' ', d36.d, ' ', d37.d, ' ', d38.d, ' ', d39.d, ' ', '\n',
d41.d, ' ', d42.d, ' ', d43.d, ' ', d44.d, ' ', d45.d,
' ', d46.d, ' ', d47.d, ' ', d48.d, ' ', d49.d, ' ', '\n',
d51.d, ' ', d52.d, ' ', d53.d, ' ', d54.d, ' ', d55.d,
' ', d56.d, ' ', d57.d, ' ', d58.d, ' ', d59.d, ' ', '\n',
d61.d, ' ', d62.d, ' ', d63.d, ' ', d64.d, ' ', d65.d,
' ', d66.d, ' ', d67.d, ' ', d68.d, ' ', d69.d, ' ', '\n',
d71.d, ' ', d72.d, ' ', d73.d, ' ', d74.d, ' ', d75.d,
' ', d76.d, ' ', d77.d, ' ', d78.d, ' ', d79.d, ' ', '\n',
d81.d, ' ', d82.d, ' ', d83.d, ' ', d84.d, ' ', d85.d,
' ', d86.d, ' ', d87.d, ' ', d88.d, ' ', d89.d, ' ', '\n',
d91.d, ' ', d92.d, ' ', d93.d, ' ', d94.d, ' ', d95.d,
' ', d96.d, ' ', d97.d, ' ', d98.d, ' ', d99.d, ' ', '\n'
) AS solution
FROM digits d11
INNER JOIN digits d12
ON COALESCE(d12.d = ( SELECT d FROM start WHERE i = 1 AND
j = 2 ), 1)
AND d12.d != d11.d
INNER JOIN digits d13
ON COALESCE(d13.d = ( SELECT d FROM start WHERE i = 1 AND
j = 3 ), 1)
AND d13.d != d11.d AND d13.d != d12.d
INNER JOIN digits d14
ON COALESCE(d14.d = ( SELECT d FROM start WHERE i = 1 AND
j = 4 ), 1)
AND d14.d != d11.d AND d14.d != d12.d AND d14.d != d13.d
INNER JOIN digits d15
ON COALESCE(d15.d = ( SELECT d FROM start WHERE i = 1 AND
j = 5 ), 1)
AND d15.d != d11.d AND d15.d != d12.d AND d15.d != d13.d
AND d15.d != d14.d
INNER JOIN digits d16
ON COALESCE(d16.d = ( SELECT d FROM start WHERE i = 1 AND
j = 6 ), 1)
AND d16.d != d11.d AND d16.d != d12.d AND d16.d != d13.d
AND d16.d != d14.d AND d16.d != d15.d
INNER JOIN digits d17
ON COALESCE(d17.d = ( SELECT d FROM start WHERE i = 1 AND
j = 7 ), 1)
AND d17.d != d11.d AND d17.d != d12.d AND d17.d != d13.d
AND d17.d != d14.d AND d17.d != d15.d AND d17.d != d16.d
INNER JOIN digits d18
ON COALESCE(d18.d = ( SELECT d FROM start WHERE i = 1 AND
j = 8 ), 1)
AND d18.d != d11.d AND d18.d != d12.d AND d18.d != d13.d
AND d18.d != d14.d AND d18.d != d15.d AND d18.d != d16.d AND d18.d !=
d17.d
INNER JOIN digits d19
ON COALESCE(d19.d = ( SELECT d FROM start WHERE i = 1 AND
j = 9 ), 1)
AND d19.d != d11.d AND d19.d != d12.d AND d19.d != d13.d
AND d19.d != d14.d AND d19.d != d15.d AND d19.d != d16.d AND d19.d !=
d17.d AND d19.d != d18.d
INNER JOIN digits d21
ON COALESCE(d21.d = ( SELECT d FROM start WHERE i = 2 AND
j = 1 ), 1)
AND d21.d != d11.d
INNER JOIN digits d22
ON COALESCE(d22.d = ( SELECT d FROM start WHERE i = 2 AND
j = 2 ), 1)
AND d22.d != d21.d
AND d22.d != d12.d
AND d22.d != d11.d
INNER JOIN digits d23
ON COALESCE(d23.d = ( SELECT d FROM start WHERE i = 2 AND
j = 3 ), 1)
AND d23.d != d21.d AND d23.d != d22.d
AND d23.d != d13.d
AND d23.d != d11.d AND d23.d != d12.d
INNER JOIN digits d24
ON COALESCE(d24.d = ( SELECT d FROM start WHERE i = 2 AND
j = 4 ), 1)
AND d24.d != d21.d AND d24.d != d22.d AND d24.d != d23.d
AND d24.d != d14.d
INNER JOIN digits d25
ON COALESCE(d25.d = ( SELECT d FROM start WHERE i = 2 AND
j = 5 ), 1)
AND d25.d != d21.d AND d25.d != d22.d AND d25.d != d23.d
AND d25.d != d24.d
AND d25.d != d15.d
AND d25.d != d14.d
INNER JOIN digits d26
ON COALESCE(d26.d = ( SELECT d FROM start WHERE i = 2 AND
j = 6 ), 1)
AND d26.d != d21.d AND d26.d != d22.d AND d26.d != d23.d
AND d26.d != d24.d AND d26.d != d25.d
AND d26.d != d16.d
AND d26.d != d14.d AND d26.d != d15.d
INNER JOIN digits d27
ON COALESCE(d27.d = ( SELECT d FROM start WHERE i = 2 AND
j = 7 ), 1)
AND d27.d != d21.d AND d27.d != d22.d AND d27.d != d23.d
AND d27.d != d24.d AND d27.d != d25.d AND d27.d != d26.d
AND d27.d != d17.d
INNER JOIN digits d28
ON COALESCE(d28.d = ( SELECT d FROM start WHERE i = 2 AND
j = 8 ), 1)
AND d28.d != d21.d AND d28.d != d22.d AND d28.d != d23.d
AND d28.d != d24.d AND d28.d != d25.d AND d28.d != d26.d AND d28.d !=
d27.d
AND d28.d != d18.d
AND d28.d != d17.d
INNER JOIN digits d29
ON COALESCE(d29.d = ( SELECT d FROM start WHERE i = 2 AND
j = 9 ), 1)
AND d29.d != d21.d AND d29.d != d22.d AND d29.d != d23.d
AND d29.d != d24.d AND d29.d != d25.d AND d29.d != d26.d AND d29.d !=
d27.d AND d29.d != d28.d
AND d29.d != d19.d
AND d29.d != d17.d AND d29.d != d18.d
INNER JOIN digits d31
ON COALESCE(d31.d = ( SELECT d FROM start WHERE i = 3 AND
j = 1 ), 1)
AND d31.d != d11.d AND d31.d != d21.d
INNER JOIN digits d32
ON COALESCE(d32.d = ( SELECT d FROM start WHERE i = 3 AND
j = 2 ), 1)
AND d32.d != d31.d
AND d32.d != d12.d AND d32.d != d22.d
INNER JOIN digits d33
ON COALESCE(d33.d = ( SELECT d FROM start WHERE i = 3 AND
j = 3 ), 1)
AND d33.d != d31.d AND d33.d != d32.d
AND d33.d != d13.d AND d33.d != d23.d
INNER JOIN digits d34
ON COALESCE(d34.d = ( SELECT d FROM start WHERE i = 3 AND
j = 4 ), 1)
AND d34.d != d31.d AND d34.d != d32.d AND d34.d != d33.d
AND d34.d != d14.d AND d34.d != d24.d
INNER JOIN digits d35
ON COALESCE(d35.d = ( SELECT d FROM start WHERE i = 3 AND
j = 5 ), 1)
AND d35.d != d31.d AND d35.d != d32.d AND d35.d != d33.d
AND d35.d != d34.d
AND d35.d != d15.d AND d35.d != d25.d
INNER JOIN digits d36
ON COALESCE(d36.d = ( SELECT d FROM start WHERE i = 3 AND
j = 6 ), 1)
AND d36.d != d31.d AND d36.d != d32.d AND d36.d != d33.d
AND d36.d != d34.d AND d36.d != d35.d
AND d36.d != d16.d AND d36.d != d26.d
INNER JOIN digits d37
ON COALESCE(d37.d = ( SELECT d FROM start WHERE i = 3 AND
j = 7 ), 1)
AND d37.d != d31.d AND d37.d != d32.d AND d37.d != d33.d
AND d37.d != d34.d AND d37.d != d35.d AND d37.d != d36.d
AND d37.d != d17.d AND d37.d != d27.d
INNER JOIN digits d38
ON COALESCE(d38.d = ( SELECT d FROM start WHERE i = 3 AND
j = 8 ), 1)
AND d38.d != d31.d AND d38.d != d32.d AND d38.d != d33.d
AND d38.d != d34.d AND d38.d != d35.d AND d38.d != d36.d AND d38.d !=
d37.d
AND d38.d != d18.d AND d38.d != d28.d
INNER JOIN digits d39
ON COALESCE(d39.d = ( SELECT d FROM start WHERE i = 3 AND
j = 9 ), 1)
AND d39.d != d31.d AND d39.d != d32.d AND d39.d != d33.d
AND d39.d != d34.d AND d39.d != d35.d AND d39.d != d36.d AND d39.d !=
d37.d AND d39.d != d38.d
AND d39.d != d19.d AND d39.d != d29.d
INNER JOIN digits d41
ON COALESCE(d41.d = ( SELECT d FROM start WHERE i = 4 AND
j = 1 ), 1)
AND d41.d != d11.d AND d41.d != d21.d AND d41.d != d31.d
INNER JOIN digits d42
ON COALESCE(d42.d = ( SELECT d FROM start WHERE i = 4 AND
j = 2 ), 1)
AND d42.d != d41.d
AND d42.d != d12.d AND d42.d != d22.d AND d42.d != d32.d
AND d42.d != d31.d
INNER JOIN digits d43
ON COALESCE(d43.d = ( SELECT d FROM start WHERE i = 4 AND
j = 3 ), 1)
AND d43.d != d41.d AND d43.d != d42.d
AND d43.d != d13.d AND d43.d != d23.d AND d43.d != d33.d
AND d43.d != d31.d AND d43.d != d32.d
INNER JOIN digits d44
ON COALESCE(d44.d = ( SELECT d FROM start WHERE i = 4 AND
j = 4 ), 1)
AND d44.d != d41.d AND d44.d != d42.d AND d44.d != d43.d
AND d44.d != d14.d AND d44.d != d24.d AND d44.d != d34.d
INNER JOIN digits d45
ON COALESCE(d45.d = ( SELECT d FROM start WHERE i = 4 AND
j = 5 ), 1)
AND d45.d != d41.d AND d45.d != d42.d AND d45.d != d43.d
AND d45.d != d44.d
AND d45.d != d15.d AND d45.d != d25.d AND d45.d != d35.d
AND d45.d != d34.d
INNER JOIN digits d46
ON COALESCE(d46.d = ( SELECT d FROM start WHERE i = 4 AND
j = 6 ), 1)
AND d46.d != d41.d AND d46.d != d42.d AND d46.d != d43.d
AND d46.d != d44.d AND d46.d != d45.d
AND d46.d != d16.d AND d46.d != d26.d AND d46.d != d36.d
AND d46.d != d34.d AND d46.d != d35.d
INNER JOIN digits d47
ON COALESCE(d47.d = ( SELECT d FROM start WHERE i = 4 AND
j = 7 ), 1)
AND d47.d != d41.d AND d47.d != d42.d AND d47.d != d43.d
AND d47.d != d44.d AND d47.d != d45.d AND d47.d != d46.d
AND d47.d != d17.d AND d47.d != d27.d AND d47.d != d37.d
INNER JOIN digits d48
ON COALESCE(d48.d = ( SELECT d FROM start WHERE i = 4 AND
j = 8 ), 1)
AND d48.d != d41.d AND d48.d != d42.d AND d48.d != d43.d
AND d48.d != d44.d AND d48.d != d45.d AND d48.d != d46.d AND d48.d !=
d47.d
AND d48.d != d18.d AND d48.d != d28.d AND d48.d != d38.d
AND d48.d != d37.d
INNER JOIN digits d49
ON COALESCE(d49.d = ( SELECT d FROM start WHERE i = 4 AND
j = 9 ), 1)
AND d49.d != d41.d AND d49.d != d42.d AND d49.d != d43.d
AND d49.d != d44.d AND d49.d != d45.d AND d49.d != d46.d AND d49.d !=
d47.d AND d49.d != d48.d
AND d49.d != d19.d AND d49.d != d29.d AND d49.d != d39.d
AND d49.d != d37.d AND d49.d != d38.d
INNER JOIN digits d51
ON COALESCE(d51.d = ( SELECT d FROM start WHERE i = 5 AND
j = 1 ), 1)
AND d51.d != d11.d AND d51.d != d21.d AND d51.d != d31.d
AND d51.d != d41.d
INNER JOIN digits d52
ON COALESCE(d52.d = ( SELECT d FROM start WHERE i = 5 AND
j = 2 ), 1)
AND d52.d != d51.d
AND d52.d != d12.d AND d52.d != d22.d AND d52.d != d32.d
AND d52.d != d42.d
INNER JOIN digits d53
ON COALESCE(d53.d = ( SELECT d FROM start WHERE i = 5 AND
j = 3 ), 1)
AND d53.d != d51.d AND d53.d != d52.d
AND d53.d != d13.d AND d53.d != d23.d AND d53.d != d33.d
AND d53.d != d43.d
INNER JOIN digits d54
ON COALESCE(d54.d = ( SELECT d FROM start WHERE i = 5 AND
j = 4 ), 1)
AND d54.d != d51.d AND d54.d != d52.d AND d54.d != d53.d
AND d54.d != d14.d AND d54.d != d24.d AND d54.d != d34.d
AND d54.d != d44.d
INNER JOIN digits d55
ON COALESCE(d55.d = ( SELECT d FROM start WHERE i = 5 AND
j = 5 ), 1)
AND d55.d != d51.d AND d55.d != d52.d AND d55.d != d53.d
AND d55.d != d54.d
AND d55.d != d15.d AND d55.d != d25.d AND d55.d != d35.d
AND d55.d != d45.d
INNER JOIN digits d56
ON COALESCE(d56.d = ( SELECT d FROM start WHERE i = 5 AND
j = 6 ), 1)
AND d56.d != d51.d AND d56.d != d52.d AND d56.d != d53.d
AND d56.d != d54.d AND d56.d != d55.d
AND d56.d != d16.d AND d56.d != d26.d AND d56.d != d36.d
AND d56.d != d46.d
INNER JOIN digits d57
ON COALESCE(d57.d = ( SELECT d FROM start WHERE i = 5 AND
j = 7 ), 1)
AND d57.d != d51.d AND d57.d != d52.d AND d57.d != d53.d
AND d57.d != d54.d AND d57.d != d55.d AND d57.d != d56.d
AND d57.d != d17.d AND d57.d != d27.d AND d57.d != d37.d
AND d57.d != d47.d
INNER JOIN digits d58
ON COALESCE(d58.d = ( SELECT d FROM start WHERE i = 5 AND
j = 8 ), 1)
AND d58.d != d51.d AND d58.d != d52.d AND d58.d != d53.d
AND d58.d != d54.d AND d58.d != d55.d AND d58.d != d56.d AND d58.d !=
d57.d
AND d58.d != d18.d AND d58.d != d28.d AND d58.d != d38.d
AND d58.d != d48.d
INNER JOIN digits d59
ON COALESCE(d59.d = ( SELECT d FROM start WHERE i = 5 AND
j = 9 ), 1)
AND d59.d != d51.d AND d59.d != d52.d AND d59.d != d53.d
AND d59.d != d54.d AND d59.d != d55.d AND d59.d != d56.d AND d59.d !=
d57.d AND d59.d != d58.d
AND d59.d != d19.d AND d59.d != d29.d AND d59.d != d39.d
AND d59.d != d49.d
INNER JOIN digits d61
ON COALESCE(d61.d = ( SELECT d FROM start WHERE i = 6 AND
j = 1 ), 1)
AND d61.d != d11.d AND d61.d != d21.d AND d61.d != d31.d
AND d61.d != d41.d AND d61.d != d51.d
INNER JOIN digits d62
ON COALESCE(d62.d = ( SELECT d FROM start WHERE i = 6 AND
j = 2 ), 1)
AND d62.d != d61.d
AND d62.d != d12.d AND d62.d != d22.d AND d62.d != d32.d
AND d62.d != d42.d AND d62.d != d52.d
AND d62.d != d51.d
INNER JOIN digits d63
ON COALESCE(d63.d = ( SELECT d FROM start WHERE i = 6 AND
j = 3 ), 1)
AND d63.d != d61.d AND d63.d != d62.d
AND d63.d != d13.d AND d63.d != d23.d AND d63.d != d33.d
AND d63.d != d43.d AND d63.d != d53.d
AND d63.d != d51.d AND d63.d != d52.d
INNER JOIN digits d64
ON COALESCE(d64.d = ( SELECT d FROM start WHERE i = 6 AND
j = 4 ), 1)
AND d64.d != d61.d AND d64.d != d62.d AND d64.d != d63.d
AND d64.d != d14.d AND d64.d != d24.d AND d64.d != d34.d
AND d64.d != d44.d AND d64.d != d54.d
INNER JOIN digits d65
ON COALESCE(d65.d = ( SELECT d FROM start WHERE i = 6 AND
j = 5 ), 1)
AND d65.d != d61.d AND d65.d != d62.d AND d65.d != d63.d
AND d65.d != d64.d
AND d65.d != d15.d AND d65.d != d25.d AND d65.d != d35.d
AND d65.d != d45.d AND d65.d != d55.d
AND d65.d != d54.d
INNER JOIN digits d66
ON COALESCE(d66.d = ( SELECT d FROM start WHERE i = 6 AND
j = 6 ), 1)
AND d66.d != d61.d AND d66.d != d62.d AND d66.d != d63.d
AND d66.d != d64.d AND d66.d != d65.d
AND d66.d != d16.d AND d66.d != d26.d AND d66.d != d36.d
AND d66.d != d46.d AND d66.d != d56.d
AND d66.d != d54.d AND d66.d != d55.d
INNER JOIN digits d67
ON COALESCE(d67.d = ( SELECT d FROM start WHERE i = 6 AND
j = 7 ), 1)
AND d67.d != d61.d AND d67.d != d62.d AND d67.d != d63.d
AND d67.d != d64.d AND d67.d != d65.d AND d67.d != d66.d
AND d67.d != d17.d AND d67.d != d27.d AND d67.d != d37.d
AND d67.d != d47.d AND d67.d != d57.d
INNER JOIN digits d68
ON COALESCE(d68.d = ( SELECT d FROM start WHERE i = 6 AND
j = 8 ), 1)
AND d68.d != d61.d AND d68.d != d62.d AND d68.d != d63.d
AND d68.d != d64.d AND d68.d != d65.d AND d68.d != d66.d AND d68.d !=
d67.d
AND d68.d != d18.d AND d68.d != d28.d AND d68.d != d38.d
AND d68.d != d48.d AND d68.d != d58.d
AND d68.d != d57.d
INNER JOIN digits d69
ON COALESCE(d69.d = ( SELECT d FROM start WHERE i = 6 AND
j = 9 ), 1)
AND d69.d != d61.d AND d69.d != d62.d AND d69.d != d63.d
AND d69.d != d64.d AND d69.d != d65.d AND d69.d != d66.d AND d69.d !=
d67.d AND d69.d != d68.d
AND d69.d != d19.d AND d69.d != d29.d AND d69.d != d39.d
AND d69.d != d49.d AND d69.d != d59.d
AND d69.d != d57.d AND d69.d != d58.d
INNER JOIN digits d71
ON COALESCE(d71.d = ( SELECT d FROM start WHERE i = 7 AND
j = 1 ), 1)
AND d71.d != d11.d AND d71.d != d21.d AND d71.d != d31.d
AND d71.d != d41.d AND d71.d != d51.d AND d71.d != d61.d
INNER JOIN digits d72
ON COALESCE(d72.d = ( SELECT d FROM start WHERE i = 7 AND
j = 2 ), 1)
AND d72.d != d71.d
AND d72.d != d12.d AND d72.d != d22.d AND d72.d != d32.d
AND d72.d != d42.d AND d72.d != d52.d AND d72.d != d62.d
INNER JOIN digits d73
ON COALESCE(d73.d = ( SELECT d FROM start WHERE i = 7 AND
j = 3 ), 1)
AND d73.d != d71.d AND d73.d != d72.d
AND d73.d != d13.d AND d73.d != d23.d AND d73.d != d33.d
AND d73.d != d43.d AND d73.d != d53.d AND d73.d != d63.d
INNER JOIN digits d74
ON COALESCE(d74.d = ( SELECT d FROM start WHERE i = 7 AND
j = 4 ), 1)
AND d74.d != d71.d AND d74.d != d72.d AND d74.d != d73.d
AND d74.d != d14.d AND d74.d != d24.d AND d74.d != d34.d
AND d74.d != d44.d AND d74.d != d54.d AND d74.d != d64.d
INNER JOIN digits d75
ON COALESCE(d75.d = ( SELECT d FROM start WHERE i = 7 AND
j = 5 ), 1)
AND d75.d != d71.d AND d75.d != d72.d AND d75.d != d73.d
AND d75.d != d74.d
AND d75.d != d15.d AND d75.d != d25.d AND d75.d != d35.d
AND d75.d != d45.d AND d75.d != d55.d AND d75.d != d65.d
INNER JOIN digits d76
ON COALESCE(d76.d = ( SELECT d FROM start WHERE i = 7 AND
j = 6 ), 1)
AND d76.d != d71.d AND d76.d != d72.d AND d76.d != d73.d
AND d76.d != d74.d AND d76.d != d75.d
AND d76.d != d16.d AND d76.d != d26.d AND d76.d != d36.d
AND d76.d != d46.d AND d76.d != d56.d AND d76.d != d66.d
INNER JOIN digits d77
ON COALESCE(d77.d = ( SELECT d FROM start WHERE i = 7 AND
j = 7 ), 1)
AND d77.d != d71.d AND d77.d != d72.d AND d77.d != d73.d
AND d77.d != d74.d AND d77.d != d75.d AND d77.d != d76.d
AND d77.d != d17.d AND d77.d != d27.d AND d77.d != d37.d
AND d77.d != d47.d AND d77.d != d57.d AND d77.d != d67.d
INNER JOIN digits d78
ON COALESCE(d78.d = ( SELECT d FROM start WHERE i = 7 AND
j = 8 ), 1)
AND d78.d != d71.d AND d78.d != d72.d AND d78.d != d73.d
AND d78.d != d74.d AND d78.d != d75.d AND d78.d != d76.d AND d78.d !=
d77.d
AND d78.d != d18.d AND d78.d != d28.d AND d78.d != d38.d
AND d78.d != d48.d AND d78.d != d58.d AND d78.d != d68.d
INNER JOIN digits d79
ON COALESCE(d79.d = ( SELECT d FROM start WHERE i = 7 AND
j = 9 ), 1)
AND d79.d != d71.d AND d79.d != d72.d AND d79.d != d73.d
AND d79.d != d74.d AND d79.d != d75.d AND d79.d != d76.d AND d79.d !=
d77.d AND d79.d != d78.d
AND d79.d != d19.d AND d79.d != d29.d AND d79.d != d39.d
AND d79.d != d49.d AND d79.d != d59.d AND d79.d != d69.d
INNER JOIN digits d81
ON COALESCE(d81.d = ( SELECT d FROM start WHERE i = 8 AND
j = 1 ), 1)
AND d81.d != d11.d AND d81.d != d21.d AND d81.d != d31.d
AND d81.d != d41.d AND d81.d != d51.d AND d81.d != d61.d AND d81.d !=
d71.d
INNER JOIN digits d82
ON COALESCE(d82.d = ( SELECT d FROM start WHERE i = 8 AND
j = 2 ), 1)
AND d82.d != d81.d
AND d82.d != d12.d AND d82.d != d22.d AND d82.d != d32.d
AND d82.d != d42.d AND d82.d != d52.d AND d82.d != d62.d AND d82.d !=
d72.d
AND d82.d != d71.d
INNER JOIN digits d83
ON COALESCE(d83.d = ( SELECT d FROM start WHERE i = 8 AND
j = 3 ), 1)
AND d83.d != d81.d AND d83.d != d82.d
AND d83.d != d13.d AND d83.d != d23.d AND d83.d != d33.d
AND d83.d != d43.d AND d83.d != d53.d AND d83.d != d63.d AND d83.d !=
d73.d
AND d83.d != d71.d AND d83.d != d72.d
INNER JOIN digits d84
ON COALESCE(d84.d = ( SELECT d FROM start WHERE i = 8 AND
j = 4 ), 1)
AND d84.d != d81.d AND d84.d != d82.d AND d84.d != d83.d
AND d84.d != d14.d AND d84.d != d24.d AND d84.d != d34.d
AND d84.d != d44.d AND d84.d != d54.d AND d84.d != d64.d AND d84.d !=
d74.d
INNER JOIN digits d85
ON COALESCE(d85.d = ( SELECT d FROM start WHERE i = 8 AND
j = 5 ), 1)
AND d85.d != d81.d AND d85.d != d82.d AND d85.d != d83.d
AND d85.d != d84.d
AND d85.d != d15.d AND d85.d != d25.d AND d85.d != d35.d
AND d85.d != d45.d AND d85.d != d55.d AND d85.d != d65.d AND d85.d !=
d75.d
AND d85.d != d74.d
INNER JOIN digits d86
ON COALESCE(d86.d = ( SELECT d FROM start WHERE i = 8 AND
j = 6 ), 1)
AND d86.d != d81.d AND d86.d != d82.d AND d86.d != d83.d
AND d86.d != d84.d AND d86.d != d85.d
AND d86.d != d16.d AND d86.d != d26.d AND d86.d != d36.d
AND d86.d != d46.d AND d86.d != d56.d AND d86.d != d66.d AND d86.d !=
d76.d
AND d86.d != d74.d AND d86.d != d75.d
INNER JOIN digits d87
ON COALESCE(d87.d = ( SELECT d FROM start WHERE i = 8 AND
j = 7 ), 1)
AND d87.d != d81.d AND d87.d != d82.d AND d87.d != d83.d
AND d87.d != d84.d AND d87.d != d85.d AND d87.d != d86.d
AND d87.d != d17.d AND d87.d != d27.d AND d87.d != d37.d
AND d87.d != d47.d AND d87.d != d57.d AND d87.d != d67.d AND d87.d !=
d77.d
INNER JOIN digits d88
ON COALESCE(d88.d = ( SELECT d FROM start WHERE i = 8 AND
j = 8 ), 1)
AND d88.d != d81.d AND d88.d != d82.d AND d88.d != d83.d
AND d88.d != d84.d AND d88.d != d85.d AND d88.d != d86.d AND d88.d !=
d87.d
AND d88.d != d18.d AND d88.d != d28.d AND d88.d != d38.d
AND d88.d != d48.d AND d88.d != d58.d AND d88.d != d68.d AND d88.d !=
d78.d
AND d88.d != d77.d
INNER JOIN digits d89
ON COALESCE(d89.d = ( SELECT d FROM start WHERE i = 8 AND
j = 9 ), 1)
AND d89.d != d81.d AND d89.d != d82.d AND d89.d != d83.d
AND d89.d != d84.d AND d89.d != d85.d AND d89.d != d86.d AND d89.d !=
d87.d AND d89.d != d88.d
AND d89.d != d19.d AND d89.d != d29.d AND d89.d != d39.d
AND d89.d != d49.d AND d89.d != d59.d AND d89.d != d69.d AND d89.d !=
d79.d
AND d89.d != d77.d AND d89.d != d78.d
INNER JOIN digits d91
ON COALESCE(d91.d = ( SELECT d FROM start WHERE i = 9 AND
j = 1 ), 1)
AND d91.d != d11.d AND d91.d != d21.d AND d91.d != d31.d
AND d91.d != d41.d AND d91.d != d51.d AND d91.d != d61.d AND d91.d !=
d71.d AND d91.d != d81.d
INNER JOIN digits d92
ON COALESCE(d92.d = ( SELECT d FROM start WHERE i = 9 AND
j = 2 ), 1)
AND d92.d != d91.d
AND d92.d != d12.d AND d92.d != d22.d AND d92.d != d32.d
AND d92.d != d42.d AND d92.d != d52.d AND d92.d != d62.d AND d92.d !=
d72.d AND d92.d != d82.d
INNER JOIN digits d93
ON COALESCE(d93.d = ( SELECT d FROM start WHERE i = 9 AND
j = 3 ), 1)
AND d93.d != d91.d AND d93.d != d92.d
AND d93.d != d13.d AND d93.d != d23.d AND d93.d != d33.d
AND d93.d != d43.d AND d93.d != d53.d AND d93.d != d63.d AND d93.d !=
d73.d AND d93.d != d83.d
INNER JOIN digits d94
ON COALESCE(d94.d = ( SELECT d FROM start WHERE i = 9 AND
j = 4 ), 1)
AND d94.d != d91.d AND d94.d != d92.d AND d94.d != d93.d
AND d94.d != d14.d AND d94.d != d24.d AND d94.d != d34.d
AND d94.d != d44.d AND d94.d != d54.d AND d94.d != d64.d AND d94.d !=
d74.d AND d94.d != d84.d
INNER JOIN digits d95
ON COALESCE(d95.d = ( SELECT d FROM start WHERE i = 9 AND
j = 5 ), 1)
AND d95.d != d91.d AND d95.d != d92.d AND d95.d != d93.d
AND d95.d != d94.d
AND d95.d != d15.d AND d95.d != d25.d AND d95.d != d35.d
AND d95.d != d45.d AND d95.d != d55.d AND d95.d != d65.d AND d95.d !=
d75.d AND d95.d != d85.d
INNER JOIN digits d96
ON COALESCE(d96.d = ( SELECT d FROM start WHERE i = 9 AND
j = 6 ), 1)
AND d96.d != d91.d AND d96.d != d92.d AND d96.d != d93.d
AND d96.d != d94.d AND d96.d != d95.d
AND d96.d != d16.d AND d96.d != d26.d AND d96.d != d36.d
AND d96.d != d46.d AND d96.d != d56.d AND d96.d != d66.d AND d96.d !=
d76.d AND d96.d != d86.d
INNER JOIN digits d97
ON COALESCE(d97.d = ( SELECT d FROM start WHERE i = 9 AND
j = 7 ), 1)
AND d97.d != d91.d AND d97.d != d92.d AND d97.d != d93.d
AND d97.d != d94.d AND d97.d != d95.d AND d97.d != d96.d
AND d97.d != d17.d AND d97.d != d27.d AND d97.d != d37.d
AND d97.d != d47.d AND d97.d != d57.d AND d97.d != d67.d AND d97.d !=
d77.d AND d97.d != d87.d
INNER JOIN digits d98
ON COALESCE(d98.d = ( SELECT d FROM start WHERE i = 9 AND
j = 8 ), 1)
AND d98.d != d91.d AND d98.d != d92.d AND d98.d != d93.d
AND d98.d != d94.d AND d98.d != d95.d AND d98.d != d96.d AND d98.d !=
d97.d
AND d98.d != d18.d AND d98.d != d28.d AND d98.d != d38.d
AND d98.d != d48.d AND d98.d != d58.d AND d98.d != d68.d AND d98.d !=
d78.d AND d98.d != d88.d
INNER JOIN digits d99
ON COALESCE(d99.d = ( SELECT d FROM start WHERE i = 9 AND
j = 9 ), 1)
AND d99.d != d91.d AND d99.d != d92.d AND d99.d != d93.d
AND d99.d != d94.d AND d99.d != d95.d AND d99.d != d96.d AND d99.d !=
d97.d AND d99.d != d98.d
AND d99.d != d19.d AND d99.d != d29.d AND d99.d != d39.d
AND d99.d != d49.d AND d99.d != d59.d AND d99.d != d69.d AND d99.d !=
d79.d AND d99.d != d89.d
WHERE COALESCE(d11.d = ( SELECT d FROM start WHERE i = 1 AND
j = 1 ), 1)
;







On May 7, 1:45 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> 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.

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

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

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
==================

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