In this blog post, you’ll learn more about the Sybase Error There is no way to join to ‘%1’ and the reason for receiving this error
Sybase SQL Error Message
There is no way to join to ‘%1’
Reason for this Error
The server cannot discover a valid join condition involving this table. If the join is an outer join, you may be missing an ON clause. If the join is a KEY JOIN, the server cannot discover a foreign key-primary key relationship with this table that can be used to generate the join condition. If the join is a NATURAL JOIN, the table has no common column names with the table expression it is being joined to.