select users.FirstName || ' ' || users.LastName,
Country.State, State.PostalRegion, Country.name from
users as users
join ShippingAddress as Ship on users.ID = Ship.UserID
join State as state on Ship.StateCode = state.stateID
join Country as country on state.countryId = Country.code
where users.ID = '101';
That was so easy and totally necessary. You know things are done Right™ when a 12-core machine takes 15 seconds to produce a page full of addresses; cause that's how long it took in 1975; when a kilobyte of memory set you back $10,000.