"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"
Trådstart#1
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"
