Hi,
Is there a way to get join to join 2 files even if in one file one of the records does not exist?
i.e. 1st file
aaa 50
bbb 60
2nd file
aaa 40

So i want to join the 2 files together and get the following output:
aaa 50 aaa 40
bbb 60 bbb 0

Is this possible???
Thanks
Jason