Вот запрос

SELECT
(SELECT TOP 1 F+' '+ I FROM Members WHERE Members.ID=SchoolMembers.Member_id) as Name,
SchoolMembers.Member_id,
MAX(AdviceToSpeeches.Date) AS LastDate,
Members.sex

FROM SchoolMembers
INNER JOIN Member ON Members.ID=SchoolMembers.Member_id
LEFT JOIN AdviceToSpeeches ON AdviceToSpeeches.member_id=SchoolMembers.Member_id
WHERE SchoolMembers.Reci Like :RECI
GROUP BY SchoolMembers.Member_id
ORDER BY MAX(AdviceToSpeeches.Date)


пишет, что:
Ошибка синтаксиса (пропущен оператор) в выражении запроса 'Members.ID=SchoolMembers.Member_id
LEFT JOIN AdviceToSpeeches ON AdviceToSpeeches.member_id=SchoolMembers.Member_id'