Thank you, Frank, your suggestion worked for a while until I stumbled over a
different set of record combinations, which I try to illustrate like this:
Input1:
A1 A1
A1 X1
A1 X2
Input2:
A1 123
X1 123
X1 ABC
Expected output:
A1 A1 123
A1 X1 123
A1 X1 ABC
i.e. the second column in input1 acts as key to the first column in input2,
and I need to report on the combined values (3 columns). But I get:
X1 123
A1 A1 123
A1 X1 123
(This includes the final sort in your code.) I've tried what I believe to be
any existing variation of the proposal you gave me but I get nowhere, not
even close. What am I doing wrong?
Rob
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html