'LEFT JOIN: The multi-part identifier "_" could not be bound

For the below query

SELECT TOP 1000 tb.firstName
    ,tb.secondName
    ,tb.startYear
    ,nb.primaryName
    ,tr.averageScore
    ,tr.numVotes
    ,g.subjectDescription
    ,tb.isActive
FROM team_basics tb
    ,ground g
    ,info_basics nb
INNER JOIN title_ground tg ON tb.ident = tg.ident
INNER JOIN name_title nt ON tb.ident = nt.ident
LEFT JOIN title_ratings tr ON tb.ident = tr.ident
WHERE nb.nconst = nt.nconst
    AND tg.groundId = g.groundId
ORDER BY tr.averageScore DESC
    ,tb.startYear DESC;

I am getting following error:

The multi-part identifier "tb.ident" could not be bound.

Earlier these were implicit joins but trying to resolve i changed them to explicit inner joins but still I am getting this error. What can I try next?

sqltsqlsql-server-2014


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions