Message : QRY2217
Field for first join must be from primary file.
Message Long Text :
Cause . . . . . : This query is using a matched primary join or unmatched primary join type (option 2 or 3 on the Specify Type of Join display). Therefore, one of the fields for the first join must be from the primary file. (For example, you might specify the first field on the left as T01.CUSTNAME, assuming that the primary file has an ID of T01 and a field name of CUSTNAME.) The fields from the primary file are listed first in the list of fields at the bottom of the display. They have the first file ID listed. Recovery . . . : Specify a field from the primary file as one of the fields in the first comparison. Or, if you want to change how the selected files are to be joined, press F12 to go to the Specify How to Join Files display and type a 1 (matched records) in the Type of join prompt.