Modified fieldnames in query result

[Choppers]

I'm running a SELECT query, over several tables. Each table has a field called 'last_updated'. When i browse the results of the query, the field have been renamed :

last_updated_1
last_updated_2
last_updated_3

Can anyone suggest an easy way to tell which field is from which table ?

[gto]

select
table_1.last_updated as last_updated_tbl1
table_2.last_updated as last_updated_tbl2
table_3.last_updated as last_updated_tbl3
from table_1, table_2, table_3


The "AS" directive change the name of field in resultset.

[Choppers]

Thanks gto, that'll do nicely.

I was hoping the tzquery component might hold the info somewhere, but i guess i'm probably just being lazy.

Thanks.