Re: Creating a work file with SQL in CL

[rob@xxxxxxxxx]

WRKMSGD MSGID(QRY2211) MSGF(QQRYMSG)
Message . . . . :   Join test cannot have both fields from the same file 
ID. 
Recovery  . . . :   Change the join test so the two fields have different 
file
  IDs.  To specify a test with two fields from the same file ID, go to the 
 
  Select Records display after specifying the join test(s).  

Assuming that you ARE doing a join and it looks something like this
select ordno, ...
from ordhead join orddtl on ordno=ordno

Then you need to do one of three things

1
select ordhead.ordno, ...
from ordhead join orddtl on ordhead.ordno = orddtl.ordno

2
select H.ordno, ...
from ordhead H join orddtl D on H.ordno=D.ordno

3 (V5R4 or above only)
select ordhead.ordno, ...
from ordhead join orddtl using ordno


Rob Berendt