On 7/7/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> 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.
I see my mistake, he actually did create the view and the second select was from the view not the source table.
