14 lines
530 B
SQL
14 lines
530 B
SQL
SELECT c.id_cliente, c.nombre_cliente, SUM(dvi.valor) AS valor
|
|
FROM documento_ventas dv JOIN documento_ventas_has_item dvi ON (
|
|
dv.id_documento=dvi.id_documento AND dv.id_sucursal=dvi.id_sucursal )
|
|
JOIN cliente c ON ( c.id_cliente=dv.id_cliente )
|
|
JOIN cliente_has_sucursal cs ON ( c.id_cliente=cs.id_cliente AND
|
|
cs.id_sucursal=dv.id_sucursal )
|
|
WHERE
|
|
LEFT(dv.id_documento,2) RLIKE "F|D[^0-9MP]"
|
|
AND NOT (dv.id_cliente LIKE "999")
|
|
AND YEAR(dv.fecha) = YEAR('2008-01-01')
|
|
GROUP BY c.id_cliente
|
|
ORDER BY c.nombre_cliente ASC
|
|
|