It should not but you may also try Full Outer join.
Thanks for responding. Yes, I did try outer and right join, it doesn't seem to work. Does it have anything to do with the data sources types?
I myself have not tried using these particular Data sources, that's why I thought That you may try full outer join and it should work.