Renaming columns

  • Thread starter Thread starter Kevin Burton
  • Start date Start date
K

Kevin Burton

I have a compilcated SELECT statement that brings together
multiple tables. Some of the columns in the tables have
the same name. I would like to rename those columns as
something prefixed by the table name. I can do this
using 'AS' but then I have to list every column. I like
using '*' as I get all of the columns. Is there any way I
can rename the columns and still use '*'?

Kevin
 
Thank you for your response.

What is the name of the newsgroup that would handle SQL
type questions. The closest I found was this group and the
ADO group.

Thanks again.

Kevin
 
Back
Top