COUNT fra en anden tabel ved brug af join

SELECT LendingStatus.Status, Products.Productname, Products.Serial_number, Deposits.Amount, Lendings.DeliveryDate, Lendings.Id AS LendingId, Products.Id AS ProductId, (select count(*) from comments where LendingID = Lendings.Id) AS Comments FROM Lendings
    LEFT JOIN Products ON Lendings.ProductId = Products.Id
    LEFT JOIN LendingStatus ON Lendings.StatusId = LendingStatus.Id
    LEFT JOIN Deposits ON Lendings.DepositId = Deposits.Id
    WHERE PersonId = 561 ORDER BY DeliveryDate DESC

Jeg får desværre fejlen:
The multi-part identifier "LendingComments.Id" could not be bound.

ved den hvad  Lendings.Id'et er?

Du skrev at feltet hed lendingID, så måske skal det være LendingComments.LendingID  istedet for LendingComments.Id

tak