Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-10 : 09:11:27
|
| Sharon writes "I have created the following query, it uses alias. I have tried placing the alias in single and double quotes and it is still kicking out as an error. How do you use an alias in a query?SELECT DISTINCT Sum([Construction Cost]) AS [SubTotal Construction], [SubTotal Construction]*[Contractor Tax Rate] AS Tax, FROM JobConstructionCost INNER JOIN [JobDetails Query] ON (JobConstructionCost.[Project Number] = [JobDetails Query].[Project Number]) AND (JobConstructionCost.[Job Number] = [JobDetails Query].[Job Number])GROUP BY [JobDetails Query].[Project Number], [JobDetails Query].[Job Number], [JobDetails Query].[Contractor Tax Rate]" |
|
|
|
|
|
Using an alias in a query