gan ane mau nanya ada yg salah gk sama query ane SELECT x.fnqty, y.fnqty, y.ftstock_group_code, y.ftstock_type_code FROM tlquota_item X JOIN(SELECT SUM(a.fnqty) AS fnqty,a.ftstock_type_code,a.ftstock_group_code FROM txsatsdn_global_det a LEFT JOIN txsatsdn_global_hdr b ON a.ftsatsdn_no=b.ftsatsdn