摘要: 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. 阅读全文
posted @ 2012-12-10 10:58 717806198 阅读(144) 评论(0) 推荐(0) 编辑