CONSULTA DENTRO DE OUTRA CONSULTA SQL

HELDERMOTA 21/09/2012 18:53:49
#410208

Criei a query abaixo, e preciso que me retorne, também, os campos do 2o select (C1_NUM AS NUMSC, C1_CC AS CCUSTO, C1_SOLICIT AS SOLICIT, CTT_DESC01 AS NOMECC), porém só me retorna o que esta no 1o select.

O que tem de errado?

SELECT C8_FILIAL, C8_NUM AS NUMCOTA, C8_PRODUTO AS CODPRD, C8_UM AS UND, C8_QUANT AS QTDE, C8_PRECO AS UNIT,
C8_TOTAL AS VRTOTAL, C8_COND AS CONDPG, C8_FORNECE AS CODFOR, C8_LOJA AS LOJAFOR, C8_EMISSAO AS DTEMIS,
C8_NUMPED AS NUMPED, C8_DATPRF AS PZOENT, C8_VALIDA AS DTNEC, A2_NOME AS NOMEFOR,
B1_DESC AS NOMEPRD, B1_EMIN PTOPED, E4_DESCRI AS NOMECPG
FROM SC8010 C8, SA2010 A2, SB1010 B1, SE4010 E4
WHERE EXISTS
(SELECT C1_NUM AS NUMSC, C1_CC AS CCUSTO, C1_SOLICIT AS SOLICIT, CTT_DESC01 AS NOMECC
FROM SC1010 C1, CTT010 CTT
WHERE C1.D_E_L_E_T_ <> [ô]*[ô]
AND CTT.D_E_L_E_T_ <> [ô]*[ô]
AND C1_FILIAL = [ô]01[ô]
AND C1_COTACAO = [ô]000008[ô]
AND C1_CC = CTT_CUSTO)
AND C8.D_E_L_E_T_ <> [ô]*[ô]
AND A2.D_E_L_E_T_ <> [ô]*[ô]
AND B1.D_E_L_E_T_ <> [ô]*[ô]
AND E4.D_E_L_E_T_ <> [ô]*[ô]
AND C8_FILIAL = [ô]01[ô]
AND C8_NUM = [ô]000008[ô]
AND C8_FORNECE = A2_COD
AND C8_LOJA = A2_LOJA
AND C8_PRODUTO = B1_COD
AND C8_COND = E4_CODIGO
ORDER BY C8_PRODUTO, A2_NOME

Valeu Helder