Firebird 1.5 classic on Windows. Is it possible to have a SQL with union all and an order by that includes a field that is not in the selects?
eg: select fieldA, fieldB from table1 where fieldA starting with 'bd' union all select fieldA, fieldB from table1 where fieldA starting with 'bi' order by fieldA asc, fieldC asc In case you wondered why I used a union here, it is as I found it be a lot faster than using an OR. RBS