Hola soy nueva aqui y agradeceria que alguien me oriente sobre alguna alternativa
tengo que listar las ventas de un mes definido, tengo este query
SELECT YEAR( tran_date ) AS anio,
MONTH( tran_date ) AS mes,
DAY(tran_date) AS dia,
SUM(ov_amount + ov_gst + ov_freight + ov_freight_tax + ov_discount) AS amount
FROM 0_debtor_trans
WHERE TYPE =13
AND MONTH(tran_date) = '2'
AND YEAR(tran_date) = '2011'
GROUP BY DAY( tran_date )
ORDER BY DAY( tran_date )
lo malo de este : solo me devuelve los dias con movimientos y yo necesito TODOS los dias aunque el resultado sea cero
intente esto sin resultado favorable
SELECT YEAR( tran_date ) AS anio,
MONTH( tran_date ) AS mes,
DAY(tran_date) AS dia,
REPEAT
SET x = x + 1;
SUM(ov_amount + ov_gst + ov_freight + ov_freight_tax + ov_discount) AS x;
UNTIL x > 30
END REPEAT
FROM 0_debtor_trans
WHERE TYPE =13
AND MONTH(tran_date) = '2'
AND YEAR(tran_date) = '2011'
GROUP BY DAY( tran_date )
ORDER BY MONTH( tran_date ), DAY( tran_date )
De antemano muchas gracias por cualquier sugerencia