The materialized view cannot be changed to immediate because COUNT(*) must be part of the SELECT list

Error constant SQLE_UPDATABLE_MATVIEW_MISSING_COUNT
ODBC 2 state 42000
ODBC 3 state ERROR
Severity 15
SQLCODE -1199
SQLSTATE 42WC6
Sybase error code 13316
 Probable cause
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1