SQL Query question. what's wrong with this query?

[zykes]

I have this query that produces Syntax Error(missing operator) in query operation ForumTopics.Top icID = ForumReply.Topi cID LEFT OUTER JOIN
Members ON ForumTopics.Wri ttenBy = Members.Member_ ID


this is the query:
SELECT ForumTopics.Top icID, ForumTopics.Top icName, Members.FName, COUNT(ForumRepl y.ReplyID) AS Reply, MAX(ForumReply. ReplyDate) AS LastPost
FROM ForumTopics INNER JOIN
ForumReply ON ForumTopics.Top icID = ForumReply.Topi cID LEFT OUTER JOIN
Members ON ForumTopics.Wri ttenBy = Members.Member_ ID
GROUP BY ForumTopics.Top icID, ForumTopics.Top ic, ForumTopics.Cat egoryID, Members.FName
HAVING (ForumTopics.Ca tegoryID = 1)
order by LastPost desc;

What is missing in this query? Need Help please...

[radcaesar]

Don't mix that formumtopics in both the joins.

Can i know, What u want to select now ?

:)

I have this query that produces Syntax Error(missing operator) in query operation ForumTopics.Top icID = ForumReply.Topi cID LEFT OUTER JOIN
Members ON ForumTopics.Wri ttenBy = Members.Member_ ID


this is the query:
SELECT ForumTopics.Top icID, ForumTopics.Top icName, Members.FName, COUNT(ForumRepl y.ReplyID) AS Reply, MAX(ForumReply. ReplyDate) AS LastPost
FROM ForumTopics INNER JOIN
ForumReply ON ForumTopics.Top icID = ForumReply.Topi cID LEFT OUTER JOIN
Members ON ForumTopics.Wri ttenBy = Members.Member_ ID
GROUP BY ForumTopics.Top icID, ForumTopics.Top ic, ForumTopics.Cat egoryID, Members.FName
HAVING (ForumTopics.Ca tegoryID = 1)
order by LastPost desc;

What is missing in this query? Need Help please...

[iburyak]

You have

ForumTopics.Top icName

in select statement and in group by

ForumTopics.Top ic


You should group by the same columns that you have in select statement.


Good Luck.

[zykes]

Thanks for the info.... got the solution...