Select Where exist in table 2

 SELECT * FROM tb_barang_temp WHERE kode_barcode IN (SELECT DISTINCT kode_barcode FROM tb_barang)

UPDATE TABLE 1 WHERE ID=TABLE 2

 UPDATE `tb_barang_temp` AS t1

    JOIN `tb_type` AS t2 

    ON t1.type=t2.type

SET t1.`type`=t2.id