I have this query that produces Syntax Error(missing operator) in query operation ForumTopics.TopicID = ForumReply.TopicID LEFT OUTER JOIN
Members ON ForumTopics.WrittenBy = Members.Member_ID in MS Access
this is the query:
SELECT ForumTopics.TopicID, ForumTopics.TopicName, Members.FName, COUNT(ForumReply.ReplyID) AS Reply, MAX(ForumReply.ReplyDate) AS LastPost
FROM ForumTopics INNER JOIN
ForumReply ON ForumTopics.TopicID = ForumReply.TopicID LEFT OUTER JOIN
Members ON ForumTopics.WrittenBy = Members.Member_ID
GROUP BY ForumTopics.TopicID, ForumTopics.Topic, ForumTopics.CategoryID, Members.FName
HAVING (ForumTopics.CategoryID = 1)
order by LastPost desc;
What is missing in this query? Need Help please...