Ambiguous column name 'Associate_ID'.

Question

 

Query as follows,

 

select Associate_ID as assid,IsActive,value from

[CentralRepository].[dbo].[vw_CentralRepository_Associate_Details] AP

inner join [CentralRepository].[dbo].[vw_CentralRepository_Contacts] CAD

ON CAD.[Associate_ID]=AP.[Associate_ID]

 

 

When i run the above query shows error as follows

 

Ambiguous column name 'Associate_ID'.

 

what is the problem in my above query. please help me.