> It looks like CompId is the column name but you > place it second in your other query. The second name > in most SQL syntax is the alias, not the real column name.What was an alias in SELECT becomes a column name in the resulting VIEW. This is the whole point of alias in the first place.
They don't seem to be in the right order. You don't need to create an alias explicitly to create a view.
