SELECT k.[no_polis]
      --,k.[id_jenis_klaim]
      ,jk.deskripsi AS jenis_klaim
      --,k.[id_item_klaim]
      ,ik.deskripsi AS item_klaim
      --,k.[id_diagnosa]
      ,k.[tgl_pengajuan]
      ,k.[tgl_kejadian]
      ,k.[keterangan]
      ,k.[kuantitas]
      ,k.[jml_diajukan]
      --,k.[id_bank]
      ,b.nama_bank
      ,k.[bank_cabang]
      ,k.[no_rekening]
      ,k.[nama_rekening]
      --,k.[no_klaim]
      ,k.[create_date]
      --,k.[create_by]
      ,usc.Nama AS create_by
      ,k.[submitted_date]
      --,k.[submitted_by]
      ,uss.Nama AS submitted_by 
      --,k.[id_unit_pelayanan_create]
      ,upc.deskripsi AS unit_pelayanan_create
FROM  [WebBranches].[dbo].[web_klaim] k INNER JOIN
      [IndInsurance].[dbo].[item_klaim] ik ON k.id_item_klaim=ik.id_item_klaim AND k.id_jenis_klaim=ik.id_jenis_klaim INNER JOIN
      [IndInsurance].[dbo].[jenis_klaim] jk ON k.id_jenis_klaim=jk.id_jenis_klaim INNER JOIN
      [IndInsurance].[dbo].[bank] b ON k.id_bank=b.id_bank INNER JOIN
      [IndInsurance].[dbo].[unit_pelayanan] upc ON k.id_unit_pelayanan_create=upc.id_unit_pelayanan INNER JOIN
      [IndInsurance].[dbo].[gUser_Name] usc ON k.create_by=usc.Id_User INNER JOIN
      [IndInsurance].[dbo].[gUser_Name] uss ON k.submitted_by=uss.Id_User
WHERE 
  k.id_unit_pelayanan_create='0009' 
  AND k.create_date>='2013-11-01' AND k.submitted_date<'2014-04-01' 
  AND k.submitted=1 
ORDER BY k.submitted_date

SELECT * FROM IndInsurance.dbo.item_klaim
SELECT * FROM IndInsurance.dbo.jenis_klaim
SELECT * FROM IndInsurance.dbo.bank