I have a design like the one attached to this post and i want to be able to query the tiers table and return the name field from the 3 tables related to tiers.
I want the the firstname and lastname in Person concatenated to name
In the end i want something like this
1 Gabriel G
3 My group