>Sorry, can't understand.
>what is column number?
>As I said :

Sorry your query is too long, so I give you an example:

Select a,b, (select c from x where f1=t1.f2) as offers from table T1 where
b=z order by 3;

3 here mean offers, because firebird doesn't support order by colum alias.

a = column number 1;
b = column number 2;
offers= column number 3;

regards
agung w http://www.firebird-indonesia.net