Ansicht
Dokumentation

QRY2217 - Field for first join must be from primary file. ( OS/400 )

QRY2217 - Field for first join must be from primary file. ( OS/400 )

Addresses (Business Address Services)   PERFORM Short Reference  
This documentation is copyright by IBM.
SAP E-Book


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.

Message File : QQRYMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3229 Date: 20240329 Time: 094138     sap01-206 ( 3 ms )