Join Table to another Crosstab Query

[hellind2]

I have a working cross-tab query as below:

TRANSFORM Sum(A.[Traded Volume]) AS VOLUME_FYTD
SELECT A.ENTITY, A.[business type], A.REGION_GROUP, A.region2, A.country
FROM DT_VOLUME2 AS A
GROUP BY A.ENTITY, A.[business type], A.REGION_GROUP, A.region2, A.country
PIVOT A.product_group

Then I want to join this query to another table, like this:

SELECT A.*, B.*
FROM [TABLEA] AS A 
LEFT JOIN (
TRANSFORM Sum(A.[Traded Volume]) AS VOLUME_FYTD
SELECT A.ENTITY, A.[business type], A.REGION_GROUP, A.region2, A.country
FROM DT_VOLUME2 AS A
GROUP BY A.ENTITY, A.[business type], A.REGION_GROUP, A.region2, A.country
PIVOT A.product_group
) AS B ON A.ENTITY=B.ENTITY

But I am getting syntax error.

[jforbes]

What error are you getting?

I haven't really studied your query, but it seems odd that you are using "A" as an alias for two different tables. I would change one of them to "C" or maybe something more descriptive.