15/08/2010, 08:28
|
| | | Fecha de Ingreso: agosto-2010
Mensajes: 1
Antigüedad: 14 años, 7 meses Puntos: 0 | |
| Ayuda con vista :S ...
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 .... |