27,579
社区成员
发帖
与我相关
我的任务
分享
select * from employees a order by (select income-outcome from salary where employeeid=a.employeeid)
select t1.name,t1.employeeID,t1.workyear,t1.sex,t1.birthday from employees t1
inner join salary t2 on t1.employeeID=t2.employeeID
order by t2.inCome desc
select t1.name,t1.employeeID,t1.workyear,t1.sex,t1.birthday from employees t1
left join salary t2 on t1.employeeID=t2.employeeID
order by t2.inCome desc