Multiple tables

Easytrieve SQL files can be defined with multiple tables, that is, tables can be joined. Referencing a file that was defined with multiple tables results in a JOIN for all defined tables.

Example


    FILE FILEIN (TABLE1, TABLE2)