This query has no errors, but I can not save the view because it continuously tells me that there is an syntax error.
This happens even in version 8, if I try my query in a new tab it works without problems
Can you verify the error for the next updates?
Code: Select all
SELECT
sucursales.idsucursal AS idsucursal,
sucursales_mails_templates.idtemplate AS idtemplate,
sucursales_mails_templates.tipo AS tipo,
sucursales_mails_templates.diaenvio AS diaenvio
FROM sucursales
INNER JOIN sucursales_mails_templates
ON sucursales.idsucursal = sucursales_mails_templates.idsucursal
WHERE DAY(CURDATE())=sucursales_mails_templates.diaenvio;