Access Error using link table

M

Matt

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
ODBC Error en Organigrama en Visio. 0
Access error using SQL Server 0
"ODBC Call Failed" Error When You Run a Query with an Outer Join Against Linked SQL Server Tables 2
what the heck does this mean? 8
ODBC error on linked SQL server table, by Access 2003 0
Connection failed error number 3151 3
linked table from ACCESS 3

Top