Erro while join table in SQL
- by Color Shadow
I have two tables that have relationship with UserName field. Based on UserName column, I want to get ID from CarReserve table. Here is my SQL statement:
SELECT CarReserve.ID 
FROM CarReserve 
 INNER JOIN aspnet_Users ON CarReserve.UserName = aspnet_Users.UserName 
WHERE UserName = @UserName
Unfortunately, I am getting this warning:
  Ambiguous column name "UserName"
Can anyone here tell me what is wrong with my statement?