We're using Informix 7.24 UC5 and Baan IV b3.
My select statement:
select tiitm001.dsca:sitm.dsca, tiitm001_1.dsca:mitm.dsca
from tiitm001, tiitm001 tiitm001_1


What does the "_1" part mean in this statement when attached to my table name?

The tiitm001_1 is an alias name. Because the select is retrieving two different tiitm001 records, the Select statement needs an alias name for the duplicate table. In the FROM clause you can list the tables separated by a comma, to list an alias for a table you put another name after the table but before the comma. Then you can reference fields from this table via the alias name.

Hope this helps

Debbie Korst
RMCis