Syntax Error with Inner Joins

[shauns1]

Hi

Does anyone know why I'm getting the following error with the Query below?

Syntax Error (Missing Operator) in query expression 'e ON e.ThreadID=t.ThreadID
INNER JOIN tblUsers AS u ON u.UserID=t.CreatorID'

The query is:

SELECT t.ThreadID,t.Thread, t.CreationDate, count(e.EntryID),u.Username
FROM spPFApprovedThreads AS t
INNER JOIN spPFApprovedEntries AS e ON e.ThreadID=t.ThreadID
INNER JOIN tblUsers as u ON u.UserID = t.CreatorID
GROUP BY t.ThreadID,t.Thread,t.CreationDate, u.Username
ORDER BY t.ThreadID;

Thanks in advance

Shaun

 

[PHV]

SELECT t.ThreadID,t.Thread, t.CreationDate, count(e.EntryID),u.Username
FROM (spPFApprovedThreads AS t
INNER JOIN spPFApprovedEntries AS e ON e.ThreadID=t.ThreadID)
INNER JOIN tblUsers as u ON u.UserID = t.CreatorID
GROUP BY t.ThreadID,t.Thread,t.CreationDate, u.Username
ORDER BY t.ThreadID;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shauns1]

Hi

Yes, thank you. This has resolved the issue.

Shaun