Informix Error -4437

-4437 All table names in the SELECT list must be the same as the table name

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.