SQL - Referencias cruzadas

Hola, estoy tratando de armar una consulta de referencias cruzadas en SQL Server 2000 pero no me resulta. La consulta corre bien en Access. Pueden ayudarme?

TRANSFORM SUM(BKS30_Final.TAX_AMOUNT) AS TTL_TAX_AMOUNT
SELECT FINAL.DATE_ISSUE, FINAL.AGENT_CODE, FINAL.NAME, FINAL.COMPANY_CODE, FINAL.TICKET, FINAL.INDICATOR, FINAL.TRANSACTION, FINAL.COUPON, FINAL.CURRENCY_TYPE, BKS46_Final.RESTRICTIONS, FINAL.EXCHANGE, BKS46_Final.INFORMATION, BAR65_Final.SPECIFIC_DATA, FINAL.COMMISSIONABLE_AMOUNT, FINAL.CASH_AMOUNT, FINAL.CREDIT_CARD_AMOUNT
FROM BAR65_Final INNER JOIN (BKS46_Final INNER JOIN (BKS30_Final INNER JOIN FINAL ON BKS30_Final.TICKET = FINAL.TICKET) ON BKS46_Final.TICKET = FINAL.TICKET) ON BAR65_Final.TICKET = FINAL.TICKET
WHERE (((BKS30_Final.TAX_TYPE) IS NOT NULL))
GROUP BY FINAL.DATE_ISSUE, FINAL.AGENT_CODE, FINAL.NAME, FINAL.COMPANY_CODE, FINAL.TICKET, FINAL.INDICATOR, FINAL.TRANSACTION, FINAL.COUPON, FINAL.CURRENCY, BKS46_Final.RESTRICTIONS, FINAL.EXCHANGE, BKS46_Final.INFORMATION, BAR65_Final.SPECIFIC_DATA, FINAL.COMMISSIONABLE_AMOUNT, FINAL.CASH_AMOUNT, FINAL.CREDIT_CARD_AMOUNT
ORDER BY FINAL.DATE_ISSUE, FINAL.COMPANY_CODE, FINAL.TICKET, BKS46_Final.RESTRICTIONS
PIVOT BKS30_Final.TAX_TYPE

Muchas gracias

Checa esta liga

http://www.elguille.info/colabora/NET2006/mpadierna_ReferenciasCruzadas.htm

gracias! voy a revisarlo