| agan" mau tanya ni saya buat lporan mgguan dgan source code sprti ini dan sdh brhasil di sql nya tpi di php y ko mseh eror ya mhon pncrhan thanks SELECT a.jenis_barang, a.jml_bongkar, b.jml_kemas, IF(c.jml_muat IS NULL,'',c.jml_muat) AS jumlah_muat FROM (SELECT jenis_barang,SUM(jumlah_bongkar) AS jml_bongkar FROM bongkar WHERE tgl_bongkar BETWEEN '2013-10-01' AND '2013-10-03' GROUP BY jenis_barang) a LEFT JOIN (SELECT jenis_barang,SUM(jumlah_kemas) AS jml_kemas FROM kemas WHERE tgl_kemas BETWEEN '2013-10-01' AND '2013-10-03' GROUP BY jenis_barang) b USING(jenis_barang) LEFT JOIN (SELECT jenis_barang,SUM(jumlah_muat) AS jml_muat FROM muat WHERE tgl_muat BETWEEN '2013-10-01' AND '2013-10-03' GROUP BY jenis_barang) c USING(jenis_barang); |
Tidak ada komentar:
Posting Komentar