Quick HOLD FILE QUESTION

[rfuschjr]

I have two hold files. I have confirmed the contents. I am dumbing things down for example. Here is the structure and contents of each; again I confirmed the contents with a report.

H1:
StudentId.....College
1111..........PennState
1111..........NYU

H2:
StudentId.....SATscore
1111..........1170
1111..........1030

I want to join the two hold files and expect this result:

StudentId.....College.....SATscore
1111..........PennState...1170
1111..........PennState...1030
1111..........NYU.........1170
1111..........NYU.........1030

*make believe there was a mailing or something to each college collecting SAT scores...who knows...the issue is that after I join H1 to H2 on StudentId as a Single Instance Left Outer Join and run a report off the result I instead get:

StudentId.....College.....SATscore
1111..........PennState...1170
1111..........NYU.........1170

I made this example up but no matter how many different tables I try this with...it always works the same way...shows each individual item in H1 and only pairs it to the FIRST item it finds in H2.

What the heck am I doing wrong! THANKS!