Query

select kibc.Tahun as tahunaudit,kibcasaldo.Tahun,year(kibcasaldo.tgl_perolehan) as thn_perolehan,kibcasaldo.No_Register,kibc.Kd_Bidang,kibc.Kd_Unit,kibc.Kd_Sub,kibc.kd_upb,kibcasaldo.Kondisi,kibc.Kondisi as kondisiaudit,kibc.idpemda,kibc.Kd_KA as kaaudit,kibcasaldo.kd_ka as kasaldo,kibc.harga as hargaaudit,kibcasaldo.hargaFROMbmd_20711R7.dbo.ta_fn_kib_c kibcasaldo left join bmd_20711R7.dbo.ta_fn_kib_c kibc on kibc.IDPemda = kibcasaldo.idpemdawherekibcasaldo.Kondisi in (1,2) andkibcasaldo.Kd_Bidang...