摘要:
select m.*,e.* from dbo.T_RequestMaster mleft join dbo.T_Expense eon m.RequestGuid=e.RequestGuidwhere m.RequestGuid=@RequestGuidselect e.AccountGuid,e.Amount,e.BusinessDate,e.ExpenseDailyGuid,e.PeopleGuid,e.Purpose,e.RequestGuid,a.AccountName from dbo.T_ExpenseDaily AS e LEFT OUTER JOINdbo.T_Accoun. 阅读全文