What does not seem to be in the right order? The syntax is
SELECT Expression AS Alias ...;
In the first query it appears compid is the alias, in the second
it appears it's the column id.
> You don't need to create an alias explicitly to create a view.
You don't need to have aliases, but they are convenient when you want to
later refer to those columns. Especially if the column is an expression.
In any case, I never said that an alias was mandatory in this case. I'm
just pointing out that the OP's query is correct as written, which you
appeared to doubt.
The author wrote the original message saying it was wrong,
so I thought it logical to doubt it was correct ;)
