如图,根据表B中的部门编号对表A进行排序,。。如何写sql啊??
4条回答 默认 最新
- a77712345 2016-03-25 03:54关注
select a.name,b.depart from tableA a left join tableB on a.depart=b.depart order by b.num desc
解决 无用评论 打赏 举报
select a.name,b.depart from tableA a left join tableB on a.depart=b.depart order by b.num desc