Query

SELECT a.id_barang_jadi ,b.qty_bj,a.sat_qty_bj,a.qty_bj, c.total_qty as Beli, d.qty_sdh_rakit AS Rakit, e.total_pcs AS RTJ, f.total_qty AS Jual
FROM stock_bj a
LEFT JOIN  stock_awal_bj b ON (b.id_barang_jadi = a.id_barang_jadi)
LEFT JOIN msk_brg_detail c ON (a.id_barang_jadi = c.id_br AND c.tanggal > '2012-04-14' AND c.jenis = "BARANG JADI")
LEFT JOIN rakit_detail d ON (a.id_barang_jadi = d.id_barang AND d.tanggal > '2012-04-14')
LEFT JOIN msk_rtj_detail e ON (a.id_barang_jadi = e.id_bj AND e.tanggal > '2012-04-14')
LEFT JOIN klr_jual_detail f ON (a.id_barang_jadi = f.id_bj AND f.tanggal > '2012-04-14') ORDER BY a.id_barang_jadi