List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 2 2001 12:15am
Subject:Re: Columns alias ?
View as plain text  
>  > The DuBois book explicity states that column aliases are not allowed in
>>  WHERE clauses.
>
>   I haven`t read the book, but I`m almost certain that this is
>untrue. Aliases work fine for me.

Table aliases work fine.  Do you have an example that doesn't provoke
an error with a column alias?


>
>   What concernes the first question, why the query didn`t work, then, as
>someone already said, FROM tabel was missing. And one suggestion more,
>sometimes, I can`t remember the exact situations, you could try the thing
>without as, just by writing SELECT something some FROM table order by
>some; this should work:-)
>
>Cheer,
>Siim Einfeldt

-- 
Paul DuBois, paul@stripped
Thread
Columns alias ?Renato Lins31 Dec
  • Re: Columns alias ?Bob Hall1 Jan
    • Re: Columns alias ?Rick Pasotto1 Jan
      • Re: Columns alias ?Siim Einfeldt aka Itpunk1 Jan
        • Re: Columns alias ?Paul DuBois2 Jan
          • Re: Columns alias ?Siim Einfeldt aka Itpunk2 Jan
            • Re: Columns alias ?Rick Pasotto2 Jan
              • Re: Columns alias ?Siim Einfeldt aka Itpunk2 Jan
                • Re: Columns alias ?Gerald L. Clark2 Jan
            • Re: Columns alias ?Bob Hall2 Jan