PreviousNext
Help > Development > Accessing AS/400 data > AS/400 Libraries and Files > Join Files
Join Files

 A join file is a logical file based on multiple physical files.

It joins together records from different files. It is like a permanent SQL SELECT view.

When the join can be resolved with existing indexes on physical files, the join file doesn’t spend any disk space and time.
So, it can be interesting to create join files, and use it with WinDev in file tables with linked fields. Instead of reading by key for each linked field, WinDev will get all the field values in a logical record.

 

A Join File can be accessed in Read Only mode.