SQL查询无法正常使用多个连接子句

I have been working on this Query for quite a while. I just got a resolution for part of it and now trying to add that query to my big one, I am having some problems with the output of the query.I have been working on this Query for quite a w