[firebase-br] Erro no Select

[José Franco Pereira Junior]

Bom dia,

Alguém poderia me ajudar a tirar o erro que o Delphi 7 acusa no comando abaixo:

SELECT CD_DISCO.DSC_CODIGO, CD_DISCO.DSC_ESTILO, qryGenEst.GEN_DESCR, 
qryGenEst.EST_DESCR FROM (SELECT TB_ESTILO.EST_CODIGO, TB_GENERO.GEN_DESCR, 
TB_ESTILO.EST_DESCR FROM TB_GENERO INNER JOIN TB_ESTILO ON 
TB_GENERO.GEN_CODIGO = TB_ESTILO.EST_GENERO) AS qryGenEst INNER JOIN 
CD_DISCO ON qryGenEst.EST_CODIGO = CD_DISCO.DSC_ESTILO GROUP BY 
CD_DISCO.DSC_CODIGO, CD_DISCO.DSC_ESTILO, qryGenEst.GEN_DESCR, 
qryGenEst.EST_DESCR, qryGenEst.EST_CODIGO ORDER BY qryGenEst.EST_CODIGO;

Estou usando InterBase 7.5.

O erro é no segundo Select, como se a sintaxe estivesse incorreta.

Obrigado. 



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 266.11.17 - Release Date: 25/5/2005