SELECT res1.id_barang_jadi,  IFNULL(res2.qty_bj,0) awal, res1.sat_qty_bj,IFNULL(res1.qty_bj,0)akhir, IFNULL(totQtyMsk,0) beli,
IFNULL(qty_sdh_rakit,0) rakit, IFNULL(total_pcs,0) rtj, IFNULL(totQtyKlr,0) jual
FROM
(
	SELECT a.id_barang_jadi,a.sat_qty_bj,a.qty_bj FROM stock_bj a
	GROUP BY a.id_barang_jadi
)res1
LEFT JOIN
(
	SELECT b.id_barang_jadi, b.qty_bj FROM stock_awal_bj b
	GROUP BY b.id_barang_jadi
)res2 on res1.id_barang_jadi = res2.id_barang_jadi
LEFT JOIN
(
	SELECT c.id_br, SUM(c.total_qty) totQtyMsk FROM msk_brg_detail c
	WHERE c.tanggal > '2012-04-14' AND c.jenis = "BARANG JADI"
	GROUP BY c.id_br HAVING SUM(c.total_qty)
)res3 on res1.id_barang_jadi = res3.id_br
LEFT JOIN
(
	SELECT d.id_barang, SUM(d.qty_sdh_rakit) qty_sdh_rakit FROM rakit_detail d
	WHERE d.tanggal > '2012-04-14'
	GROUP BY d.id_barang HAVING SUM(d.qty_sdh_rakit)
)res4 on res1.id_barang_jadi = res4.id_barang
LEFT JOIN
(
	SELECT e.id_bj, e.total_pcs FROM msk_rtj_detail e
	WHERE e.tanggal > '2012-04-14'
	GROUP BY e.id_bj
)res5 on res1.id_barang_jadi = res5.id_bj
LEFT JOIN
(
	SELECT f.id_bj, sum(f.total_qty) totQtyKlr FROM klr_jual_detail f
	WHERE f.tanggal > '2012-04-14'
	GROUP BY f.id_bj HAVING SUM(f.total_qty)
)res6 on res1.id_barang_jadi = res6.id_bj