Código sql:
Ver originalSELECT
SUM( ventas.cantidad ),
SUM( ventas.importe_venta ),
NULL
FROM ventas WHERE ventas.codigo = '$code'
AND ventas.fecha BETWEEN '$registro-01' AND '$registro-31'
UNION
SELECT
SUM( partidas.monto ),
COUNT( partidas.monto ),
NULL
FROM partidas WHERE partidas.codigo = '$code'
AND partidas.reporte BETWEEN '$registro-01' AND '$registro-31'
UNION
SELECT
SUM( pagos.importe_pago ),
COUNT( pagos.importe_pago ),
AVG(pagos.mora)
FROM pagos WHERE pagos.codigo = '$code'
AND pagos.fecha BETWEEN '$registro-01' AND '$registro-31'
UNION
SELECT
limite,
NULL,
NULL
FROM limite WHERE limite.codigo = '$code'
AND limite.fecha BETWEEN '$registro-01' AND '$registro-31'