--- Thomas Beutin <tyrone@laokoon.IN-Berlin.DE> wrote:
> My typical queries are like that:
> SELECT count(a_id) AS count
> FROM (
> SELECT DISTINCT a_id FROM stat_pages
> WHERE m_id = '35'
> AND visit >= '2002-09-01'
> AND visit <= '2002-09-30'
> ) AS foo;
>
You can do SELECT count(DISTINCT a_id) FROM ...
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com