in reply to Joining two files on common field

Should we try to guess what you might be doing wrong or do you want to show us your code?

-sam