permisi gan, left join menurut ane sih begini: misal tabel A (id, type, barang, harga) |id|type|barang|harga| |1|A|a1|100| S E N S O R|A|a2S E N S O R00| S E N S O R|A|a3S E N S O R00| |4|B|a1|100| |5|B|a2S E N S O R00| S E N S O R|B|a3S E N S O R00| query t1 select id, barang, harga from table A...