> > 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:-)
Paul DuBois, paul@stripped