Re: Creating a work file with SQL in CL

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