select 
            FRealAmt=b.FTaxSubmitAmt,
            FRealAmtFor=b.FTaxSubmitAmtFor,
            FRealDeprID = a.FDeptID,
            FRealEmpID= a.FProposerID ,
            FRealExpID= b.FExpID,
            FRealItemClassID= b.FItemClassID,
            FRealItemID=b.FItemID,
            FProjectID = 1000,
            a.FCurrencyID as FCurrencyID,
            c.Fname as department,
            d.Fname as employee,
            REVERSE(LEFT(REVERSE(e.FFullName),CHARINDEX('_',Reverse(e.FFullName))-1)) as ItemName,
            e.Fname as expensive,
            FCheckDate,
            FDate,
            a.FCheckStatus as FCheckStatus,
            b.Fnote as fnote,
            e.FitemClassID as FitemClassID,
            e.Fnumber as Fnumber
        from t_BM_ExpReimbursement a
            Inner Join t_BM_ExpReimbursementEntry b On a.FID=b.FID
            Inner Join t_Currency cur on cur.FCurrencyID =a.FCurrencyID
            Inner Join t_item c on c.FItemID=a.FDeptID
            Inner Join t_item d on d.FItemID=a.FProposerID
            Inner Join t_item e on e.FItemID=b.FExpID

建议你提供详细的资料：
例如表的结构，表之间的关系，测试数据，相关算法及需要的结果。
这样有助于我们理解你的意思，更主要的是能尽快让你获得答案或解决问题的方法。