Subject How to get table alias from SQL for columns
Author karelnagy
In our application we have SQL select like this:
select A.*, B.*
from TABLE_A A
left outer join TABLE_B on ....
Fields in TABLE_A: ID, DESC
Fields in TABLE_B: ID, DESC

A user sorts data by clicking table header (application adds "order
by" clausule to SQL). But I need to know table alias for each column
to create reqular order by. For field name I can use
getSourceColumnName (). It would by nice to have getTableAliasName ()
to create "order by B.DESC" - in FB2.0 "order by TABLE_B.DESC" doesn't
Is there any posibility to find table alias name?
Thanks for answer