Query-of-Query learning ...

[Conti]

Is it posible to have a query of this query

SELECT A.ENTRY_ID, A.TITLE, B.UNAME, B.ENTRY_DATE, B.COMMENT_ID
FROM BLOG_ENTRIES A INNER JOIN BLOG_COMMENTS B ON A.ENTRY_ID=B.ENTRY_ID AND
A.BLOG_ID=B.BLOG_ID
WHERE A.BLOG_ID=<cfqueryparam cfsqltype="cf_sql_integer"
value="#arguments.blog_id#">
ORDER BY B.ENTRY_DATE DESC

where A.TITLE is DISTINCT and I have a count of occurrences of each A.TITLE ?

Thank You very much.
ContiW

[mxstu]

Something like this should work.

<cfquery dbType="query" name="getTitleCount">
SELECT TITLE, COUNT(*) AS CountOfOccurrences
FROM yourFirstQuery
GROUP BY TITLE
</cfquery>

<!--- show results --->
<cfdump var="#getTitleCount#">