create view total
as
SELECT top 100 percent A.Code_Name,B.n_manage, B.n_product, B.youngwoo, B.JK, B.SJ,b.n_man,b.n_girl,a.sor_fld,
 b.ab_man, b.ab_girl,yman,ygirl,jkman,jkgirl,sjman,sjgirl,B.n_manage+B.n_product+ B.youngwoo+B.JK+ B.SJ as total
FROM Infosys005 A
      INNER Join
(
SELECT Dept,
 SUM(CASE WHEN Gubun = '1' and workstatus <> '2' THEN 1 ELSE 0 END) AS n_manage,
 SUM(CASE WHEN Gubun = '2'  and workstatus <> '2' THEN 1 ELSE 0 END) AS n_product,
 SUM(CASE WHEN Gubun = '3'  and workstatus <> '2' THEN 1 ELSE 0 END) AS youngwoo,
 SUM(CASE WHEN Gubun = '4'  and workstatus <> '2' THEN 1 ELSE 0 END) AS JK,
 SUM(CASE WHEN Gubun = '5'  and workstatus <> '2' THEN 1 ELSE 0 END) AS SJ,
    sum(case when sex = '1' and workstatus <> '2' and (gubun='1' or gubun='2') then 1 else 0 end) as n_man,
    sum(case when sex ='2' and workstatus <> '2' and (gubun='1' or gubun='2') then 1 else 0 end) as n_girl,
    sum(case when sex='1' and workstatus <> '2' and (gubun='3' or gubun='4' or gubun='5') then 1 else 0 end) as ab_man,
    sum(case when sex='2' and workstatus <> '2' and (gubun='3' or gubun='4'or gubun='5') then 1 else 0 end) as ab_girl,
    sum(case when sex='1' and workstatus <> '2' and  gubun='3' then 1 else 0 end) as yman,
    sum(case when sex='2' and workstatus <> '2' and  gubun='3' then 1 else 0 end) as ygirl,
    sum(case when sex='1' and workstatus <> '2' and  gubun='4' then 1 else 0 end) as jkman,
    sum(case when sex='2' and workstatus <> '2' and  gubun='4' then 1 else 0 end) as jkgirl,
    sum(case when sex='1' and workstatus <> '2' and  gubun='5' then 1 else 0 end) as sjman,
    sum(case when sex='2' and workstatus <> '2' and  gubun='5' then 1 else 0 end) as sjgirl
FROM HURE001 A
 GROUP BY Dept) B
ON A.Sub_Code = B.Dept
where a.main_code ='inf005' and sub_code <> '$'
order by a.sor_fld

 select 시에는 a.sor_fld로 정렬이 잘 되는데...
view 를 만들어서 
select * From total 이런식으로 실행하면..정렬이 되지 않습니다. 환장 하겠네요.. 
답변 부탁드립니다.
감사합니다.