Buenos dias me gustaaria saber si me podrain ayudar con el sgte script
CREATE VIEW lala AS
(SELECT rut,1 as tipo FROM recurso WHERE id_recurso < 3)
UNION
(SELECT rut,2 as tipo FROM recurso WHERE id_recurso = 3)
UNION
(SELECT rut,3 as tipo FROM recurso WHERE id_recurso > 3)
me tira un error ....
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'union AS
(SELECT rut,1 as tipo FROM recurso WHERE id_recurso < 3)
UNION
(SELE' at line 1
que puede ser ?? ... muchas gracias de antemano ....