select s.targetname,s.optname,s.score,na.x as tar,n.x as opt from sc_score_rec as s
left join
(select x=ROW_NUMBER() over(order by type asc,username desc),username from sc_user where dr=0)as n on n.username=s.optname
left join
(select x=ROW_NUMBER() over(order by type asc,username desc),username from sc_user where dr=0)as na on na.username=s.targetname
where s.dr=0 and s.targetname
in
(select username from sc_user where type=0 and dr=0) order by tar
有没有更简洁的查询语句 能实现相同的功能