strange query

[pete M <pmorgan@xxxxxxxx>]

I'm running this query agains a mysql database, its a list of statuses 
with a joined table that shows the number of job in that status with 
more than 2. However I get the error

Unknown column 'c' in 'where clause'

select  job_stats.job_stat_id, job_stat, job_stat_code,
count(works.job_stat_id) as c
from job_stats
inner join works on job_stats.job_stat_id = works.job_stat_id
where c > 2
group by job_stats.job_stat_id, job_stat, job_stat_code
order by job_stats.job_stat_order asc

Any idead anyone please

tia
pedro

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php