1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
SELECT mailboxnumber, SUM(NB1), SUM(NB2), SUM(NB3)
FROM
(
select c.mailboxnumber, count(*) as NB1, 0 as NB2, 0 as NB3
from BPMMessages as m, BPMCustomers as c
where c.mailboxnumber=80001
UNION
select c.mailboxnumber, 0 AS NB1, count(*) as NB2, 0 as NB3
from BPMMessages as m, BPMCustomers as c, BPMWorkersActions as w
where c.mailboxnumber=80001
UNION
select c.mailboxnumber, 0 as NB1, 0 as NB2, count(*) as NB3
from BPMMessages as m, BPMCustomers as c, BPMMailTypes as mt
where c.mailboxnumber=80001
)
GROUP BY mailboxnumber |
Partager