select 
	mr."no" as id_idruang, mr.kode_ruang as id_kdruang, mr.kdunit as id_kdunit,
	mr.st_aktif as st_status,
	mr.nama as nm_namaruang,
	mr.keterangan as des_keterangan,
	mr.kelas as tp_kelas, mr.kelompok as tp_kelompokruang, mr.ruang as tp_typeruang, mr.subsistem as tp_subsistem, mr.is_partial as tp_partial
from m_ruang mr;

//----Location - Location & SMF
select 
	mr."no" as id_idruang, mr.kode_ruang as id_kdruang, mr.kdunit as id_kdunit,
	mr.st_aktif as st_status,
	mr.nama as nm_namaruang,
	mr.keterangan as des_keterangan,
	mr.kelas as tp_kelas, mr.kelompok as tp_kelompokruang, mr.ruang as tp_typeruang, mr.subsistem as tp_subsistem, mr.is_partial as tp_partial,
	ms.kdsmf as id_kdsmf, ms.namasmf as nm_namasmf
from m_ruang mr 
left join m_unit mu on mu.kode_unit = mr.kdunit 
left join m_smf ms on ms.kdsmf = mu.smf;