Is it possible to automatically prefix a table alias
(or table name or something else even) to each column
in a select list? For example:
select a.*, b.*
from tablea a
inner tableb b
on a.id=b.aid;
results:
a_id, a_name, b_id, b_name, b_aid
CSN
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/