Order by Clause in Union

SQLServerCentral » Latest topics

Order by Clause in Union

My ORDER BY clause after joining data using UNION is not giving me correct result. Anyone has any idea why? 
[code]SELECT Mnth,ProductID,Project_Nofrom(SELECT left(

more info...