select leaveid,tblleave.employeeid,Submittime,starttime,endtime,reason,status,approverid,name as 'ApproverName' from tblleave left join tblEmployee on tblleave.ApproverID=tblEmployee.employeeid ;
select name as 'EmployeeName' from tblleave left join tblEmployee on tblleave.employeeid=tblEmployee.employeeid;
已经贴好 麻烦了~
追答select leaveid,tblleave.employeeid,Submittime,starttime,endtime,reason,status,approverid,T1.name as 'ApproverName',T2.name as 'EmployeeName'
from tblleave T0 left join tblEmployee T1 on T0.ApproverID=T1.employeeid left join tblEmployee T2 on T0.employeeid=T2.employeeid