IF there keys you can join the tables on you should do so. Also you can use SELECT DISTINCT to elimate dup rows if they are in fact the same.
Another tip is to only query for the actual data you need.
You original link to your query does not work you can just post the query in between some code blocks on this forum and we can look at it there. Your schema is also helpful.