I'm following along in a book and I have entered the following select statement and I get and error that says "Incorrect syntax near 'ProductCategoryID'". Do you folks know how I can get this bit of code to work?

SELECT -1 AS ProductCategoryID, '(All Categories)' AS NAMEUNION ProductCategoryID, NAMEFROM Production.ProdcutCategoryORDER BY NAME