IBM ISERIES SC41-5210-04 - Manual (Page 64)

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
52 Query for iSeries Use V5R2