SQL Syntax Error

[highv0ltage]

Hello, I am having an issue with a query containing some inner joins. It checks out fine within SQL 2005 but Access does not like the query syntax.

Here is my query:

SELECT TOP 5 Category.Title, article.pubDate, article.Title AS Title, * 
FROM Article 
INNER JOIN Article_Category ON Article.ID = Article_Category.ArticleID
INNER JOIN Category ON Article_Category.CategoryID = Category.ID
WHERE Article.ID IN (SELECT Article_Category.ArticleID FROM  Article_Category
WHERE Article_Category.CategoryID IN ( 
SELECT Article_Category.CategoryID 
FROM Article_Category 
WHERE Article_Category.CategoryID.ArticleID = 5132005));

Any help would be great. Thanks.

 

[PHV]

...
FROM [!]([/!]Article
INNER JOIN Article_Category ON Article.ID = Article_Category.ArticleID[!])[/!]
INNER JOIN Category ON Article_Category.CategoryID = Category.ID
...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[highv0ltage]

Thanks for the response PHV, but that didn't seem to fix it, but I'm getting a different error now. It says,"Syntax error in FROM clause.