In this blog post, you’ll learn more about the Sybase Error Shared and local tables cannot participate in a JOIN INDEX. %1 and the reason for receiving this error
Sybase SQL Error Message
Shared and local tables cannot participate in a JOIN INDEX. %1
Reason for this Error
Cannot create a join index between a main and a local table.