Sorry Guru. I got it wrong.

The error it brings is "Incorrect syntax near the keyword 'Union'.

Thanks SS Guru but it gives me the below error;

ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.