There is no way to join '%1' to '%2'

There is more than one way to join '%1' to '%2'

ASA Error Messages
Database Error Messages
Alphabetic list of error messages

There is no way to join '%1' to '%2'

Item	Value
SQLCODE	-146
Constant	SQLE_CANNOT_JOIN
SQLSTATE	53W04
Sybase error code	301
ODBC 2 State	37000
ODBC 3 State	42000
Parameter 1	Name of first table that cannot be joined.
Parameter 2	Name of second table that cannot be joined.

Probable cause

You may have attempted a KEY JOIN between two tables and there is no foreign key on one of the tables that references the primary key of the other table. You may have attempted a NATURAL JOIN between two tables that have no common column names.