Select sobre Select, como fazer?

 select A.EMP, A.CLI, A.NFI, A.DAT, A.NOP, A.NPE, A.CDPG, A.CDESA,A.DESCICMS, A.IRENDA, A.SERVICOS, B.DESPAG,
C.EFEITOVEN,C.PIS,C.FINSOCIAL, D.V2 as DESCLI, D.V4 as MUNICIPIO, D.V5 as CODEST, D.TCL as CODSEG, 
D.TCL2, D.ZONA ,D.VEN_DIRETA, E.CSG as CODSEG,E.NSG as DESSEG, F.CSG as CODCLA,F.NSG as DESCLA,G.DESZONA,
H.NOMEEST as ESTADO, 
I.NNF, I.NCL, I.NEM, I.QTE, I.VLR, I.QTECE, I.VLRCE, I.PRO, I.IPI, I.PED, I.DNF, I.NRE,I.ICMS, I.ENCPRO, I.ENCIPI,
I.ENCFIN,I.PCO, I.NTIPOCOM,I.NCOMVLRMAS,I.ALI_ICMS,I.PAI,I.PORDEM,I.NDESPADMAS,I.NBONUS,I.IDNF, 
J.V2 as DESREP, K.A2 as DESPRO,K.FATCONV,K.PLIQ,K.GRUPO,K.SGRUPO,K.CODFAB, 
L.DESCRICAO as UNIDADE, (I.QTE*.K.PLIQ) as PESO_PRO 
from ARQNFIS A 
left join ARQCPAG B on (A.CDPG=B.CODPAG) 
left join ARQNOPS C on (A.NOP=C.NOX) 
left join ARQCLIE D on (A.CLI=D.V1) 
left join ARQTCLI E on (D.TCL=E.CSG) 
left join ARQCCLI F on (D.TCL2=F.CSG) 
left join ARQZONA G on (D.ZONA=G.CODZONA) 
left join ARQESTA H on (D.V5=H.CODEST) 
left join ARQPRNF I on (A.NFI=I.NNF) 
left join ARQREPR J on (I.NRE=J.V1) 
left join ARQMER  K on (I.PRO=K.A1) 
left join ARQUNID L on (K.A3=L.COD) 
where A.EMP = ´001´ and D.V0 = ´001´ and I.NEM = ´001´ and 
A.DAT between ´01/07/2005´ and ´31/07/2005´ and 
A.CLI >= ´02238´ and A.CLI <= ´09347´ and 
A.CDPG >= ´´ and A.CDPG <= ´064´ and 
(C.EFEITOVEN = ´S´ or C.EFEITOVEN = ´D´) and A.CDESA = ´N´ and 
D.TCL >= ´01´ and D.TCL <= ´99´ and 
D.TCL2 >= ´01´ and D.TCL2 <= ´99´ and 
D.ZONA>= ´00´ and D.ZONA <= ´99´ and 
I.PRO >= ´002000000000´ and I.PRO <= ´010999999999´ and 
I.NRE >= ´001´ and I.NRE <= ´999´

select nfi,dnf,codcli,descli,nop,sum(totpro)as totpro,sum(vlrtot)as vlrtot,sum(icmstot) as icmstot,
sum(pistot)as pistot,sum(cofinstot)as cofinstot,sum(ipi)as ipi,sum(fre)as fre,sUM(VLRTOT) AS LIQUIDO 
from AQUI_PRIMEIRO_SELECT
group by nfi,dnf,codcli,descli,noP

SELECT *
FROM
  (
    SELECT * FROM CLIENTE WHERE ESTADO = SP
  )
WHERE
  LIMITECREDITO > 1000

SELECT *
FROM
  (
    SELECT * FROM CLIENTE WHERE ESTADO = SP
  ) CONS1
WHERE
  LIMITECREDITO > 1000