Dear all, I am trying the following mysql statement (probably it will be obvious that I am a newcomer):
select IMdirectory, IMljd, count(*) as N from Images where IMstid = 5, N > 10 group by IMdirectory order by IMljd; ERROR 1054: Unknown column 'N' in 'where clause' My question is: how could I select only those grouped entries that have a count number greater than e.g. 10? Cheers Gaspar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
