2007年第三季度正常客户星级

--2007年第三季度正常客户星级
select b.Corpid,b.corpname,b.Licenseno,b.Shopname,b.Principalname,nvl(a.clevel,'XH')
from mmregieinfoview b,
(select clientid,to_char(clientlevel) clevel from mmcclientgrade
where gradedate=to_date('20070701','yyyymmdd')
) a
where b.Mmclientinfoid=a.clientid(+)
and b.Bizstatus=1 and b.Canshutout in (2,3)
order by corpid,nvl(a.clevel,'0') desc