I need to add the SELECT item "C.CATEGORY_ID" to the following query:
Category_id is a column of table "blog_categories" which has in common
the column "entry_id"
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
Thank You
ContiW
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
