Informix Error -2990

-2990 The columns column1 and column2 are not in the same database table.

All columns that are cited in a single LOOKUP attribute must belong to the same table. Check the spellings of the names, and make sure that they are the columns you intended.