Informix Error -26537: INNER join refers to more than two tables
Cause and resolution
INNER join refers to more than two tables
This query was not accelerated because it contains an INNER join with an ON clause that refers to more than two tables.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26537 fires when a query isn't accelerated because an INNER join's ON clause
references more than two tables — per the official guidance.
- An
INNERjoin'sONclause spans more than two tables, per the official guidance — the direct, only cause.
Solutions / Resolution
- No action needed to "fix" this — per the official guidance, such a query runs on the database server instead.
Examples
N/A
No specific triggering statement is documented beyond an INNER ON clause spanning
more than two tables.
Diagnostic Checks
- This is an informational offload-diagnostic, not an error to fix.
Related Errors / Related Topics
- -26532 — "ON clause of LEFT OUTER refers to more than two tables" The same class
of join-table-count restriction, for
LEFT OUTERjoins rather thanINNER. - -26534 — "INNER join must be on first level of joins" A related
INNER-join restriction, on join level rather than table count. - -26536 — "INNER join contains a non-equality join between columns" A related
INNER-join restriction, on predicate type rather than table count.
An INNER join's ON clause spanned more than two tables — such queries run on the
database server instead.