Access Error using link table

I have this program and it links a few tables on a MS SQL 2003 server
into access 2003. The SQL statement below gives me the error below it.
I'm not a SQL expert but I know if I change LEFT JOIN to INNER JOIN it
does nto give me the error. Unfortunately it does not give me the
results I want. Thanks in advance for any help.

SQL STATEMENT:

SELECT tblLnk_APVEN.VENDORID, qrySel_TaxAuthority1.GROUPID,
qrySel_TaxAuthority1.AUTHORITY1, qrySel_TaxAuthority1.ITEMRATE1,
qrySel_TaxAuthority2.AUTHORITY2, qrySel_TaxAuthority2.ITEMRATE2
FROM tblLnk_APVEN LEFT JOIN (qrySel_TaxAuthority1 LEFT JOIN
qrySel_TaxAuthority2 ON qrySel_TaxAuthority1.GROUPID =
qrySel_TaxAuthority2.GROUPID) ON tblLnk_APVEN.CODETAXGRP =
qrySel_TaxAuthority1.GROUPID;


ASSOCIATED ERROR:

ODBC--call failed.

[Microsoft][ODBC SQL Server Driver][SQL Server]The Column prefix 'MS2'
does not match with a table name or alias name used in the query.
(#107)
[Microsoft][ODBC SQL Server Driver][SQL Server]The Column prefix 'MS2'
does not match with a table name or alias name used in the query.
(#107)
[Microsoft][ODBC SQL Server Driver][SQL Server]The Column prefix 'MS2'
does not match with a table name or alias name used in the query. (#107)