Posted by Ewoud Dronkert on 10/13/32 11:30

Marius III wrote:
> SELECT [...] COUNT(R.CityID) AS N [...] WHERE N > 0
> The error is: "Unknown column in Where clause 'N' ".

Yes, you can't use aliases in where clauses. See
http://dev.mysql.com/doc/refman/4.1/en/problems-with-alias.html

> BTW: Hope this newsgroup is suitable for my question.

It isn't, really. Your put PHP in the subject but the question has nothing
to do with it. Try comp.databases.mysql in the future.

--
E. Dronkert

[Back to original message]