> From: Claudio Valderrama C.
> I know that this case may be a pain:
> select f, f2 from t1 join t2 on t1.f = t2.f
> order by a;

And (afaik) this command is IB/FB extension to SQL92,
that requires that you can sort only by fields presented in SELECT clause.

Ivan
http://www.volny.cz/iprenosil/interbase