Buenas tardes
Como puedo mejorar esta consulta
Código SQL:
Ver originalSELECT f.muluid, SUM(pd.zongshuliang) AS cantidad, SUM(pd.zongshuliang * pd.precio) AS total , f.name
FROM pedidolist p
INNER JOIN pedidomov pd ON p.pedidokey = pd.pedidokey
INNER JOIN articulo a ON pd.codigo = a.codigo
INNER JOIN familia f ON f.muluid = a.muluid
WHERE p.fecha_c BETWEEN '2016-04-12' AND DATE_ADD( '2016-04-12', INTERVAL 1 DAY)
AND (a.muluid IS NOT NULL AND a.muluid != '' AND a.muluid != '0')
GROUP BY f.muluid, f.name
ORDER BY f.muluid
por que tarda mucho
Saludos