Join on multiple fields
Posted: Tue May 25, 2010 11:21 pm
Is it possible to join 2 files based on multiple fields ?
So far I have used only one field to do the join on 2 files .
Also the how would be a performance if we are comparing the 2 files having a million records each .
I would appreciate if simple example is posted to demonstrate how the join based on multiple fields work .
So far I have used only one field to do the join on 2 files .
Also the how would be a performance if we are comparing the 2 files having a million records each .
I would appreciate if simple example is posted to demonstrate how the join based on multiple fields work .