請(qǐng)教各位大俠，這個(gè)SQL語句有什么錯(cuò)�。�

sccjh

語句是：
SELECT c.*, g.name, cc.name
   FROM c, cc, s
   LEFT JOIN g ON g.id = c.id
   WHERE c.id=cc.id AND cc.id=s.id
   ORDER BY c.id

報(bào)錯(cuò)：
-19819  An ON-clause has an invalid table reference.

One of the ON clauses that you specified refers to a table that is not
within the scope of the join to which the ON clause belongs.

Check that the tables that you specify in the join criteria and join
filters of each ON clause are applicable to the join of which they are
a part.

zoukunhong

SELECT c.*, g.name, cc.name
FROM s, cc, c
LEFT JOIN g ON g.id = c.id
WHERE c.id=cc.id AND cc.id=s.id
ORDER BY c.id
另外,s表沒有用到,連接他有什么用?

sccjh

我看懂了，謝謝zoukunhong，謝謝，真是高