Previous Topic: -86 - NULL NOT ALLOWED IN COLUMN aaaaNext Topic: -101 - A SYNONYM ON A SYNONYM IS NOT ALLOWED

SQL Codes › SQL Return Codes -1 through -999 › -87 - CANNOT USE <UNION> AND <UNION ALL> IN SAME STATEMENT

-87 - CANNOT USE <UNION> AND <UNION ALL> IN SAME STATEMENT

Reason:

The SQL statement contained both UNION and UNION ALL.

The SQLSTATE that equates to this SQL return code is 0AS02.

Action:

Use one or the other.