Quien me ayuda con esta query

[Ribon]

me tira el error "all derived tables must have its won alias"

pero todas las consultas generadas tienen su alias propiamente puesto o no?

Código MySQL:

SELECT cc.dg_codigo, cc.dg_cuenta_contable,
    SUM(da.dq_debe) AS dq_debe_actual, SUM(dc.dq_debe) AS dq_debe_compare,
    SUM(da.dq_haber) AS dq_haber_actual, SUM(dc.dq_haber) AS dq_haber_compare FROM (SELECT * FROM tb_cuenta_contable WHERE dc_empresa = 1) AS cc
    JOIN (SELECT * FROM tb_comprobante_contable_detalle AS det
                LEFT JOIN (SELECT * FROM tb_comprobante_contable WHERE dc_anho_contable = 2011) AS com ON det.dc_comprobante = com.dc_comprobante) AS da ON cc.dc_cuenta_contable = da.dc_cuenta_contable
    LEFT JOIN (SELECT * FROM tb_comprobante_contable_detalle AS deta
                LEFT JOIN (SELECT * FROM tb_comprobante_contable WHERE dc_anho_contable = 2010)) AS comp ON deta.dc_comprobante = comp.dc_comprobante) AS dc ON cc.dc_cuenta_contable = dc.dc_cuenta_contable GROUP BY cc.dc_cuenta_contable
 

por fis si me pueden ayudar :P