Well you gave us a bunch of data and said "here is my results". Results of what? Presumably a query.

The problem is that you have the same column name in a number of these tables and there is nothing indicate the relation between these tables. How about if you post the query that you used and explain what you want as output?

This is a two way street. When you provide details about what you want we can help you figure out a way to get them. Otherwise we are just guessing.