Tq yahh.. Dengan sukses berjalan..
--- In [email protected], Celes Victoria <[EMAIL PROTECTED]> wrote: > > 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] >
