UNION ALL syntax error

[capronton]

Can someone explain why I get an error with the syntax below. Thanks.

SELECT * as "Route",
"All"as "Description"

UNION ALL

SELECT route.route_alpha,
route.route_alpha as "Description"
FROM route

 

[hilfy]

You can't select "*" from nothing - you need to give a dummy value to the Route field like you are to the Description field. Based on the second part of the union, I'm going to assume that Route is a string field. In this case, your query would look like this:

Select 'All' as Route, 'All' as Description

UNION ALL

Select route_alpha, route_alpha
froum route

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com