SELECT a.*,
b.Nm_Aset5 AS Nm_Aset5,
CONCAT(a.latitude, '<br>', a.longitude) AS latitude,
c.Uraian AS Kondisi
FROM ta_kib_c AS a
LEFT JOIN ref_rek5_108 AS b
ON CONCAT(a.Kd_Aset8,a.Kd_Aset80,a.Kd_Aset81,a.Kd_Aset82,a.Kd_Aset83,a.Kd_Aset84,a.Kd_Aset85)
= CONCAT(b.Kd_Aset,b.Kd_Aset0,b.Kd_Aset1,b.Kd_Aset2,b.Kd_Aset3,b.Kd_Aset4,b.Kd_Aset5)
LEFT JOIN ref_kondisi AS c
ON a.Kondisi = c.Kd_Kondisi
LEFT JOIN ta_kibcr AS d
ON d.IDPemda = a.IDPemda
WHERE d.IDPemda IS NULL
Tidak ada komentar:
Posting Komentar