Query performs the file join in two steps:

Step 1: Join the first two files, A and C.

Query joins the files in the order listed, starting with file A (CUSTOMER), and file C (ITEM). But there is no join test that compares a field in A to a field in C. Query joins every record in file A (one record at a time) to

52Query for iSeries Use V5R2

Page 64
Image 64
IBM SC41-5210-04 manual Query for iSeries Use V5R2