I am not seeing that you are joining on any fields within your inner join reference? 

If what you have said about question #2 is true, then I would not every be interested in using MS SQL ever again.  Although I have...