Re: strange query
| From: | Mikhail U. Petrov | Date: | Tue, 01 Jun 2004 15:11:19 +0000 |
| Subject: | Re: strange query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34614@lists.php.net to get a copy of this message | ||
Hi!
You should use
having c>2
instead of
where c>2.
Tuesday, June 1, 2004, 7:09:29 PM, pete wrote:
pM> I'm running this query agains a mysql database, its a list of statuses
pM> with a joined table that shows the number of job in that status with
pM> more than 2. However I get the error
pM> Unknown column 'c' in 'where clause'
pM> select job_stats.job_stat_id, job_stat, job_stat_code,
pM> count(works.job_stat_id) as c
pM> from job_stats
pM> inner join works on job_stats.job_stat_id = works.job_stat_id
where c >> 2
pM> group by job_stats.job_stat_id, job_stat, job_stat_code
pM> order by job_stats.job_stat_order asc
pM> Any idead anyone please
pM> tia
pM> pedro
--
Best regards,
Mikhail U. Petrov
mailto:mikhail@begun.ru