472,139 Members | 1,509 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,139 software developers and data experts.

MS Access Sql Query

14
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...
Jan 17 '07 #1
0 874

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Frnak McKenney | last post: by
1 post views Thread by Joris Kempen | last post: by
14 posts views Thread by Sean C. | last post: by
52 posts views Thread by Neil | last post: by
3 posts views Thread by mnjkahn via AccessMonster.com | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.