SELECT Name, lastName, address, people.conID, postnum, region FROM people JOIN countries ON people.conID = countries.conID;