Forcing alias in columnNames

  • Thread starter Thread starter John Hendrix
  • Start date Start date
J

John Hendrix

Hi,

is there a way to force Access to keep an alias in the column Name even if
there is no duplicated name.

If I perform a :
Select table1.* table2.*
From (DirtySocks AS table1 LEFT JOIN BrownShoes AS table2 ON (table2.pkID =
table1.fkID))

And both BrownShoes as DirtySocks have a Size column, only These Columns are
named
BrownShoes.Size & DirtySocks.Size, while all the others stay Alias-less.

I like to have the Alias in front of the columnName, even if there is no
duplicated ColumnName.

Is there a Way?

Thanks,
Ben
 
BrownShoes.Size & DirtySocks.Size, while all the others stay Alias-less.

SHOULD BE

table1.Size & Table2.Size ...............
 
Why not enumerate the fields in the SELECT part, rather than using *.

Yes, it's easier to use *, but it only takes a few minutes more to list all
of the fields.
 
Doug,

I have to combine 8 tables into one virtual table where rows from all tables
(except the master table) are placed behind eachother. The problem is that
the query is quite complex and Access says so (Query to complex).

I had to split up the query in 3 parts (which is not fixed and can be 4 or
2) and combine them afterwards (glueing them together again). When I glue
them together, I need those aliases. Each query returns exactly the same
number of rows.

All works quite well, the queries are automatically created, the glueing is
done, but then I'm stuck with those columns which are not nicely identified
by an alias.

BTW, the resulting virtual Table = 300 columns wide.

With regards,
Ben
 
Back
Top