Código SQL [-]SELECT P.Area, Sum(p.Monto) as Monto, sum(c.monto_compr) as Total FROM presupuesto p JOIN compras c ON (P.Empresa = c.Empresa and P.Periodo=c.Periodo) WHERE P.empresa = 'empresa1' P.periodo = '2008-04' GROUP BY P.AREA ORDER BY P.Area
SELECT P.Area, Sum(p.Monto) as Monto, sum(c.monto_compr) as Total FROM presupuesto p JOIN compras c ON (P.Empresa = c.Empresa and P.Periodo=c.Periodo) WHERE P.empresa = 'empresa1' P.periodo = '2008-04' GROUP BY P.AREA ORDER BY P.Area