In this blog post, you’ll learn more about the Sybase Error The materialized view cannot be changed to immediate because the ON conditions refer to tables which are not in the null-supplying and preserved sides of the OUTER JOINs. and the reason for receiving this error
Sybase SQL Error Message
The materialized view cannot be changed to immediate because the ON conditions refer to tables which are not in the null-supplying and preserved sides of the OUTER JOINs.
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view whose definition contains an illegal ON condition.