Add another join to a query

[Conti]

I need to add to the SELECT item "C.CATEGORY_ID" to the following query
(another join?):

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

[paross1]

Yup.

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

Phil

[Conti]

Thank You paross1. Unfortunately it does not work yet.
Tablename is correct columnName ant type also is correct.
The errorMsg returned is
Error Executing Database Query.
Syntax error (missing operator) in query expression ''.
Thanks for helping.
ContiW

[JMGibson3]

When adding joins Access (damn microsoft) requires parentheses around the
higher join(s). Try:

FROM (BLOG_ENTRIES A
INNER JOIN BLOG_COMMENTS B ON A.ENTRY_ID=B.ENTRY_ID
AND A.BLOG_ID=B.BLOG_ID)
INNER JOIN BLOG_CATEGORIES C ON A.ENTRY_ID=C.ENTRY_ID

[Conti]

That was it !
ThankYou JMGibson3
You have a good source of info. Share?
Have a nice week.
WalterConti

[paross1]

Sorry, you didn't say that it was Access. Yeah, the parentheses requirement makes Access just that much more fun for query writing! Just glad that you didn't need an outer join.

Phil :)

[Conti]

I didn't. Sorry Phil.
I have Fry's a couple of blocks away and I have got a book.
See, "outher joins" ... FUN!

WalterConti