Sybase Error – CREATE JOIN does not support joining joins. %1

In this blog post, you’ll learn more about the Sybase Error CREATE JOIN does not support joining joins. %1 and the reason for receiving this error

Sybase SQL Error Message

CREATE JOIN does not support joining joins. %1

Reason for this Error

This message is returned during CREATE JOIN INDEX when the left hand side and right hand side of a ‘FULL OUTER JOIN’ keyword set are both joins ie (A FOJ B) FOJ (C FOJ D) the join of a-b is being joined to c-d.