The multi-part identifier could not be bound. T-SQL

Question

I am trying to run this select statement:

SELECT  dbo.tblBird.EnglishName, dbo.tblMember.Last
FROM  dbo.tblBird , dbo.tblMember
JOIN dbo.tblBirdMember AS join1 ON  (join1.BirdID = dbo.tblBird.BirdID)
JOIN dbo.tblBirdMember AS join2 ON (join2.MemberID = dbo.tblMember.MemberID)

but I get this error:

Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "dbo.tblBird.BirdID" could not be bound.

I have been searching around on google for hours but I can't seem to get this going, and help is greatly appreciated!

Answer 1

It looks like you are trying to write something like:

select b.EnglishName, c.Last
from dbo.tblBirdMember a
join dbo.tblBird b          on a.BirdID = b.BirdID
join dbo.tblMember c        on a.MemberID = c.MemberID