select *
from (
select judgement.zsr, judgement.dlspy, JudgeMent.Aid,JudgeMent.CaseNum,JudgeMent.larq,JudgeMent.slqx,JudgeMent.barq,JudgeMent.fj,JudgeMent.isyqsl,JudgeMent.yqyy,JudgeMent.Xgsj,JudgeMent.Ispt,t_status.meaning from JudgeMent,t_status where 1=1 and JudgeMent.Status=t_status.code(+) and status=9
)
where zsr='aaa' or dlspy='aaa' and rownum<=500 order by AID desc;
from (
select judgement.zsr, judgement.dlspy, JudgeMent.Aid,JudgeMent.CaseNum,JudgeMent.larq,JudgeMent.slqx,JudgeMent.barq,JudgeMent.fj,JudgeMent.isyqsl,JudgeMent.yqyy,JudgeMent.Xgsj,JudgeMent.Ispt,t_status.meaning from JudgeMent,t_status where 1=1 and JudgeMent.Status=t_status.code(+) and status=9
)
where zsr='aaa' or dlspy='aaa' and rownum<=500 order by AID desc;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货