SQL-gröt

Jag har tydligen inte riktigt koll på detta med INNER JOIN.

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression '(tblPosts.UserID = tblUsers.UserID) INNER JOIN tblTopics ON (tblPosts.TopicID = tblTopics.TopicID)'.

"SELECT * FROM tblPosts INNER JOIN tblUsers ON (tblPosts.UserID = tblUsers.UserID) INNER JOIN tblTopics ON (tblPosts.TopicID = tblTopics.TopicID) WHERE tblPosts.TopicID = " & intTopicID & " AND Topic = True ORDER BY PostDate DESC"

------------------
// Skarre

[Redigerat av Skarre den 13 nov 2001]

"SELECT * FROM (tblUsers INNER JOIN tblPosts ON tblusers.UserID = tblPosts.UserID) INNER JOIN tblTopics ON tblPosts.TopicID = tblTopics.TopicID WHERE tblPosts.TopicID = " & intTopicID & " AND Topic = True ORDER BY PostDate DESC"

------------------
essentitia preter non sans multiplicandum

Tack LarsG! Dig kan man lita på. :)

------------------
// Skarre