Geo Carncross wrote: > I wrote this query back in <[EMAIL PROTECTED]> > > I also suggested the alternative: > > select count(*), count(case when seen_flag > 0 Then 1 else null end), > count(case when recent_flag > 0 then 1 else null end) FROM > dbmail_messages WHERE status < '2' and mailbox_idnr='1';
and this one works for mysql-4.0 just fine. -- ________________________________________________________________ Paul Stevens mailto:[EMAIL PROTECTED] NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] The Netherlands________________________________http://www.nfg.nl
