AW: [PUG] SQL/MySQL-Frage

[HMeissner]

hi martin,
so mal ins blaue, ungetestet:
select 
 date(datetime) as DATUM,  
 (select count(Accepted) from mails
        where Accepted=1) as ACCEPTED
 (select count(Accepted) from mails
        where Accepted=0) as REJECTED
 group by Day order by Day;
greez
h1

btw: man sollte das zählen nicht vergessen ;-)
--
----------------------------------------------------------------------------
PUG - Penguin User Group Wiesbaden - http://www.pug.org