We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

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

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

RFUMSV00 - Advance Return for Tax on Sales/Purchases   CPI1466 during Backup  
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


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.

Length: 3229 Date: 20201031 Time: 140306     sap01-206 ( 16 ms )