Run Time Error -2147217900 (80040014) - Ambiguous column name 'ID_Company'

This is code I have inherited and have been asked to debug. Screen Shot 1 shows the form that is executed that generates the error. I click 'Debug' and What is seen in Screen Shot 2 appears. I believe the numeric code indicated a possible problem with a Join satement. The .txt file attached shows the SQL statement that the error points to, 'strSQL'.
Could someone verify that I am on the right track and advise what I should do to resolve this error?
Thanks in Advance.
Screen-Shot1.JPG
Screen-Shot2.JPG
SQLstr.txt
tesla764Asked:
Who is Participating?
 
Gary DewrellSenior Network AdministratorCommented:
Both tables you are accessing have a column ID_Company. You need to fully qualify the column  table.collumn name so sql knows which ID_Company in which table you are referencing.
0
 
tesla764Author Commented:
Yes I see that I need to preface the names to make them distinguished.
thanks.
0
 
Gary DewrellSenior Network AdministratorCommented:
You are very welcome. Have a great day.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.