SELECT p.BusinessEntityID, p.FirstName, p.MiddleName, p.LastName, CONCAT(a.AddressLine1, ' ', a.AddressLine2), a.City, cr.Name, p.PersonType
FROM Person.Person p
JOIN Person.BusinessEntityAddress bea
ON bea.BusinessEntityID=p.BusinessEntityID
JOIN Person.Address a
ON a.AddressID=bea.AddressID
JOIN Person.StateProvince sp
ON a.StateProvinceID=sp.StateProvinceID
JOIN Person.CountryRegion cr
ON cr.CountryRegionCode=sp.CountryRegionCode;