多表查询后按照拼音排序

select p.FPROVINCEID,p.FPROVINCE from t_bas_province p
WHERE EXISTS (SELECT * FROM t_bas_businessdept b
INNER JOIN t_bas_city c ON b.fnewcity = c.fid WHERE (c.FFATHER = p.FPROVINCEID) and b.FISSTART is not null
and b.FISSTART !=0)
order by p.findexid,nlssort(p.fprovince,'NLS_SORT=SCHINESE_PINYIN_M')