Subject RE: [ib-support] Aliases
Author Leyne, Sean
> that's ok, but then again, this does NOT work that well:
>
> select field1 a, field2 || ', ' || field3 b
> from tablec
> order by field2 || ', ' || field3;
>
> uhm.. how do I get around this?


select field1 a, field2 || ', ' || field3 b
from tablec
order by 2;