The materialized view cannot be changed to immediate because at least one non-nullable column from any null-supplying side of an OUTER JOIN must exist in the SELECT list

Error constant SQLE_UPDATABLE_MATVIEW_ISNOTNULL
ODBC 2 state 42000
ODBC 3 state ERROR
Severity 15
SQLCODE -1508
SQLSTATE 42WE8
Sybase error code 12595
 Probable cause
 More information