Can I do this SELECT in MySQL?

[rubis]

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.

 

[robert22]

No you can't yet.
They don't have subselects! But this is expected soon.
Read their documentation on how to avoid this problem. there is a special link in the doc(html) "functionality missing for mysql" 1.4.4.1 subselects

 

[rubis]

Thank you...