SYMPTOMS
When you create a nested query against linked SQL Server tables and
the top level query contains an outer join, you receive the following
error message when you try to run the query:

ODBC--Call Failed.

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

Microsoft tells about this error, I copied this text from this link:
http://support.microsoft.com/default...b;EN-US;300830

---------------------------------------------
Does anyone knows a solution for JET 3.51?
---------------------------------------------




Andreas Lauffer, easySoft. GmbH, Germany
a.lauffer (AT) easysoft (DOT) de