Sub-Consultas

vtdeleon · #3 23-09-2005

Saludos

Claro, sino no la estubiera escribiendo aqui, y tengo un sistemita usando esa sentencia. (ODBC, FoxPro, ADO)

Sistema:

Código SQL [-]SELECT *
FROM (SELECT CODEMP, 
                           SUM(PHORRG+PHORE1) AS PAGAR,SUM(MAKEUP+PDIAXCA+IMPPIE) AS BRUTO,
                           SUM(PHORRG+PHORE1-(MAKEUP+PDIAXCA+IMPPIE) ) AS DIFERENCIA
           FROM (SELECT CODEMP,NUMSEM,TIPEMP, PHORRG,PHORE1,MAKEUP,PDIAXCA,IMPPIE
                        FROM BVNASEM
                        UNION
                        SELECT CODEMP,NUMSEM,TIPEMP, PHORRG,PHORE1,MAKEUP,PDIAXCA,IMPPIE
                         FROM BVNATSE
                        ) TUNION
           WHERE NUMSEM BETWEEN :SEM1 AND :SEM2 and tipemp='P'
           GROUP BY CODEMP
           ) AS MAKEUP
WHERE BRUTO>0 AND DIFERENCIA>0.01

Código:


CODEMP     PAGAR     BRUTO     DIFERENCIA
         1       2433    1333.59          1099.41
....
....