Error 146

Message text

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

Item

Value

SQLCode

-146

Constant

SQLE_CANNOT_JOIN

SQLState

53W04

ODBC 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 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; or you have attempted a NATURAL JOIN between two tables and the tables have no common column names.