oceannative
Programmer
Referencing thread243-1197791
I have three files that I need to join. J0 and J1 work. However, J2 and J3 (children of J0 and J1) do not... they retrieve the same data.
From Group:
FILEA.SM$FCOM/SM$FGP + FILEB.CWCO/CW$FL# + FILEC.IMLITM = ABC
To Group:
FILEA.SM$TCOM/SM$TGP + FILEB.CWCO/CW$FL# + FILEC.IMLITM = DEF
This is the join generated using the JOIN tool:
I have three files that I need to join. J0 and J1 work. However, J2 and J3 (children of J0 and J1) do not... they retrieve the same data.
From Group:
FILEA.SM$FCOM/SM$FGP + FILEB.CWCO/CW$FL# + FILEC.IMLITM = ABC
To Group:
FILEA.SM$TCOM/SM$TGP + FILEB.CWCO/CW$FL# + FILEC.IMLITM = DEF
This is the join generated using the JOIN tool:
Code:
JOIN
FILEA.FILEA.SM$FCOM AND FILEA.FILEA.SM$FGP IN FILEA TO MULTIPLE
FILEB.FILEB.CWCO AND FILEB.FILEB.CW$FL# IN FILEB AS J0
END
JOIN
FILEA.FILEA.SM$TCO AND FILEA.FILEA.SM$TGP IN FILEA TO MULTIPLE
FILEB.FILEB.CWCO AND FILEB.FILEB.CW$FL# IN FILEB AS J1
END
JOIN
FILEB.FILEB.CWLITM IN FILEA TO UNIQUE FILEC.FILEC.IMLITM IN FILEC AS J2
END
JOIN
FILEB.FILEB.CWLITM IN FILEA TO UNIQUE FILEC.FILEC.IMLITM IN FILEC AS J3
END