sum (dp.cantidad) as totalt
select sum (dp.cantidad) as total, dp.idproducto as codigo
from pedidos p, detallesdepedido dp
where p.idpedido=dp.idpedido
and p.mesenvio = 7
group by dp.idproducto
PIVOT
p.diaenvio
In CFMX i can make a query like this, if i can how i do the ouput
checo
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
