Syntax problem with query - missing operator 1

[marcoose]

Im getting the following error when I try to run this query :

Syntax error (missing operator) in query expression ".

SELECT
c.MEMBER_HOME_COUNTRY, a.Member_ID, c.MEMBER_NAME, d.PRODUCT_MARKET_NAME, a.Projected_Annual_Amount
FROM dbo_Member_Annual_Spend_Projections As a
INNER JOIN
(SELECT Member_ID,
Projection_Product_Market_ID,
Max(Date_Projection_Made) AS LatestProjectionDate
FROM dbo_Member_Annual_Spend_Projections
GROUP BY Member_ID, Projection_Product_Market_ID) As b
ON a.MEMBER_ID=b.Member_ID
AND a.Projection_Product_Market_ID= b.Projection_Product_Market_ID
INNER JOIN dbo_Member c
ON a.Member_ID=c.Member_ID
INNER JOIN dbo_Product_Market d
ON a.Projection_Product_Market_ID=d.PRODUCT_MARKET_ID;

 

[RickSpr]

Change it to:
INNER JOIN dbo_Member As c
ON a.Member_ID=c.Member_ID
INNER JOIN dbo_Product_Market As d

This is a difference of Jet SQL from ANSI SQL. Rick Sprague

 

[marcoose]

Thanks thats finally worked !