SELECT * FROM ( SELECT IdMPack AS IdMBrg, NamaPack AS NamaBrg, 'Packaging' AS Jenis, IdMProd as IdMProd, Jumlah FROM MGWSMPackPerProdD LEFT OUTER JOIN MGWSMPackPerProd ON MGWSMPackPerProdD.IdMPPD = MGWSMPackPerProd.IdMPPD UNION ALL SELECT IdMChem AS IdMBrg, NamaChem AS NamaBrg, 'Chemical' AS Jenis, IdMProd as IdMProd, Jumlah FROM MGWSMChemPerProdD LEFT OUTER JOIN MGWSMChemPerProd ON MGWSMChemPerProdD.IdMCPD = MGWSMChemPerProd.IdMCPD )tbl WHERE NamaBrg !='' AND IdMProd = 52