• I get the code you have pasted but that really isn't what i want.

    The three tables related to tiers have somethings in common, the name field except for Persons that has firstname and lastname. I want to pull data from all the three tables along with the named field