Hi all,
The following is my statement.
SELECT TW1.blk
FROM tbWORD AS TW1, tbDIV AS TD
WHERE TW1.word = TD.word
GROUP BY TW1.blk
HAVING COUNT(TW1.word) = (SELECT COUNT(word) FROM tbDIV);
Once I submit to MySQL, it said syntax error near SELECT COUNT(word) FROM tbDIV.
The following is my statement.
SELECT TW1.blk
FROM tbWORD AS TW1, tbDIV AS TD
WHERE TW1.word = TD.word
GROUP BY TW1.blk
HAVING COUNT(TW1.word) = (SELECT COUNT(word) FROM tbDIV);
Once I submit to MySQL, it said syntax error near SELECT COUNT(word) FROM tbDIV.