[indoprog-vb] [help] Query SQL

[shooting_star_halley]

Siang All

Saya mau menanyakan query Sql, ada yang bisa bantu,,

saya punya query:
select convert(varchar,wf_input_time,105) as Receive,count(*) as Total
from pemohon
group by convert(varchar,wf_input_time,105)
order by convert(varchar,wf_input_time,105)

menghasilkan:
SENT           TOTAL
06-12-2007      10
08-12-2007      10
10-12-2007      10
11-12-2007      10
12-12-2007      10
13-12-2007      10

dan query:
select convert(varchar,wf_ver_post_time,105) as Sent,count(*) as Total
from verifikasi
where wf_ver_post_time is not null
group by convert(varchar,wf_ver_post_time,105)
order by convert(varchar,wf_ver_post_time,105)

menghasilkan:
Sent          Total
10-12-2007      9
11-12-2007      11
12-12-2007      9
13-12-2007      10
14-12-2007      1

yang saya mau menanyakan bgaimana saya bisa mendapatkan hasil seperti ini:
Tanggal        Receive     Sent
06-12-2007      10          0
08-12-2007      10          0 
10-12-2007      10          9
11-12-2007      10          11
12-12-2007      10          9
13-12-2007      10          10

Terima kasih,