Unambigious column name in sql server?

Guest User

5y852

Hi Team

I have a query that wants to get total of each record, but i am now getting error on one record. 'Unambigious column name(Transaction Code). How do i fix this issue on my sql query?

select
 count([Station Description]) total,
 [Transaction Code],
 [DateTime Passed]
 from [Tracking_Server_DB].[dbo].TS_Station as stn
 inner join [Tracking_Server_DB].[dbo].[Checkpoint Movement] as mv
 on stn.[Transaction Code] = mv.[Transaction Code]
 group by [Transaction Code],[DateTime Passed]
 order by [DateTime Passed] desc

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
use table alias while selecting columns

select
count(stn.[Station Description]) total,
stn.[Transaction Code],
[DateTime Passed]
from [Tracking_Server_DB].[dbo].TS_Station as stn
inner join [Tracking_Server_DB].[dbo].[Checkpoint Movement] as mv
on stn.[Transaction Code] = mv.[Transaction Code]
group by stn.[Transaction Code],[DateTime Passed]
order by [DateTime Passed] desc