Hello, I'm trying to create a simple UNION but is not working is displaying the next message:
TITLE: Microsoft Report Designer
------------------------------
An error occurred while executing the query.
Incorrect syntax near the keyword 'UNION'.
------------------------------
ADDITIONAL INFORMATION:
Incorrect syntax near the keyword 'UNION'. (Microsoft SQL Server, Error: 156)
For help, click:
------------------------------
BUTTONS:
OK
------------------------------
And this is my UNION:
SELECT IdUsuario, Nombre
FROM Usuario
ORDER BY Nombre
UNION
SELECT Null, 'All'
How can I solve this?
TITLE: Microsoft Report Designer
------------------------------
An error occurred while executing the query.
Incorrect syntax near the keyword 'UNION'.
------------------------------
ADDITIONAL INFORMATION:
Incorrect syntax near the keyword 'UNION'. (Microsoft SQL Server, Error: 156)
For help, click:
------------------------------
BUTTONS:
OK
------------------------------
And this is my UNION:
SELECT IdUsuario, Nombre
FROM Usuario
ORDER BY Nombre
UNION
SELECT Null, 'All'
How can I solve this?