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.