Copy link to clipboard
Copied
quote:
<cfquery datasource="#request.dsn#" name="testd">
SELECT f.forumID, f.forumName, t.forumID, t.topicID, p.topicID, p.postID
FROM Forums f LEFT OUTER JOIN (SELECT Topics.forumID, COUNT(Posts.postID) as total FROM Topics LEFT JOIN Posts ON Posts.topicID = Topics.topicID GROUP BY Topics.forumID)
Topics ON Topics.forumID = Forums.forumID
</cfquery>
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:
<cfquery datasource="#request.dsn#" name="testA">
SELECT f.forumID, f.forumName, t.forumID, t.topicID
FROM Forums f LEFT OUTER JOIN Topics t ON f.forumID = t.forumID
</cfquery>
quote:
<cfquery datasource="#request.dsn#" name="testc">
SELECT Topics.forumID, COUNT(Posts.postID) as total FROM Topics LEFT JOIN Posts ON Posts.topicID = Topics.topicID GROUP BY Topics.forumID
</cfquery>
Copy link to clipboard
Copied
quote:....and do what, exactly?
I want to combine the following two queries.
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied