S
Steff
I am having trouble with a particular query using MS Query to access an
SQL server database.
The query works OK, but the alias columns are dropped and the original
column headings are used instead.
Column aliases work fine for other queries I have created with the same
system, but this one includes multiple joins, one outer join and
calculations.
Is there any point in me persevering with this, or should I just resort
to stored procedures? Is it the outer join, the calculations (or both)
that MS Query doesn't like?
Suggestions greatly appreciated!
SQL server database.
The query works OK, but the alias columns are dropped and the original
column headings are used instead.
Column aliases work fine for other queries I have created with the same
system, but this one includes multiple joins, one outer join and
calculations.
Is there any point in me persevering with this, or should I just resort
to stored procedures? Is it the outer join, the calculations (or both)
that MS Query doesn't like?
Suggestions greatly appreciated!