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

Reply via email to