多表连接查询

select m.*,e.* from dbo.T_RequestMaster m left join dbo.T_Expense e on m.RequestGuid=e.RequestGuid where m.RequestGuid=@RequestGuid select e.AccountGuid,e.Amount,e.BusinessDate,e.ExpenseDailyGuid,e.PeopleGuid,e.Purpose,e.RequestGuid, a.AccountName from dbo.T_ExpenseDaily AS e LEFT OUTER JOIN dbo.T_AccountItem AS a ON a.AccountGuid = e.AccountGuid and e.RequestGuid=@RequestGuid

转载于:https://www.cnblogs.com/GreenGrass/archive/2012/12/10/2811004.html