Home about IT Motivation Course Sales Project About Me

Sunday, June 07, 2009

Create value 0 for data if no value or NULL

select kategori.nama_kategori , count(berita.nama_berita) as hitung
from kategori left join berita on
kategori.nama_kategori = berita.nama_berita
and berita.tgl_berita >= '2009-06-01'
group by kategori.nama_kategori


ACT 1
Email 0
Hardware 0
Internet 0
Network 0
Others 0
Software 0
VMI 1

No comments: