In this blog post, you’ll learn more about the Sybase Error The materialized view cannot be changed to immediate because the ON conditions must refer to both sides of the OUTER JOIN. and the reason for receiving this error
Sybase SQL Error Message
The materialized view cannot be changed to immediate because the ON conditions must refer to both sides of the OUTER JOIN.
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view whose definition contains an illegal ON condition.