Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Ambiguous column name 'Associate_ID'.
narasiman rao
Jun 2 2016 1:27 AM
272
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
sqlserver stroed proc
pin check/ verification on stored procedure