In this post, you’ll learn about the SQL error code -142 in InterSystems IRIS database the reason why you are receiving the SQL error message when using the InterSystems IRIS data platform
Error Code :
-142
Reason for the Error code -142 in InterSystems IRIS DBMS
Cardinality mismatch between the view-column-list and view query’s SELECT clause