gini

SELECT m.no_order,m.amount,m.diskon,m.defee,m.net_price,m.rounded,m.vat,m.total_semua,e.cust_no,r.part_number,r.description,
r.qty,r.price,r.total
 FROM tb_transaksi m
                  left join  tb_customer e on m.cust_no = e.cust_no
                  left join  tb_barang r on m.no_order on r.no_order=m.no_order
Group by m.no_order,e.cust_no,r.part_number