select a.tgl,b.Total_pemohon,c.Total_pengirim from
( select distinct tgl from (
select distinct convert(varchar, wf_input_ time,105) as tgl from pemohon
union
select distinct convert(varchar, wf_ver_post_ time,105) from verifikasi
where wf_ver_post_ time is not null
)a_1
) a
left join (
select convert(varchar, wf_input_ time,105) as Receive,ifnull(count(*),0)
as Total_pemohon
from pemohon
group by convert(varchar, wf_input_ time,105))b on a.tgl = b.receive
left join (
select convert(varchar, wf_ver_post_ time,105) as Sent,ifnull(count(*),0)
as Total_pengirim
from verifikasi
where wf_ver_post_ time is not null
group by convert(varchar, wf_ver_post_ time,105))c on a.tgl = c.Sent
order by a.tgl
__________________________________________________________________
Yahoo! Singapore Answers
Real people. Real questions. Real answers. Share what you know at
http://answers.yahoo.com.sg
[Non-text portions of this message have been removed]
