Oninit
Talk to an expert →

Informix Error -4437: All table names in the SELECT list must be the same as the table name in the FROM clause.

Cause and resolution

All table names in the SELECT list must be the same as the table name in the FROM clause.

One of the table names used in the list of columns to select does not appear in the FROM clause. Possibly you simply misspelled the name in one of the two places. Or you might have used a table alias in the select-list but forgot to define it in the FROM clause.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-4437 fires when a table name qualifying a column in the SELECT list doesn't appear in the FROM clause — per the official guidance, this may be a spelling error, or a table alias used in the select-list but never defined in FROM.

  1. A misspelled table name shared between the SELECT list and FROM clause, per the official guidance — the first named cause.
  2. A table alias used in the select-list but not defined in FROM, per the official guidance — the second named cause.
Solutions / Resolution
  1. Check the spelling of the table name in both places, per the official guidance.
  2. If an alias was used, define it in the FROM clause, per the official guidance.
Examples
A select-list alias not defined in FROM
SELECT o.order_id FROM orders;
-- -4437: "o" is used in the select list but not defined as an alias in FROM
Corrected
SELECT o.order_id FROM orders o;
Diagnostic Checks
  1. Check every table name/alias used in the SELECT list against the FROM clause, and correct any mismatch.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -4437 in this set yet.

A SELECT-list table name/alias doesn't appear in FROM — check spelling, and define any alias used.