Is it possible to form a field of multiple references to other tables?

Is the address field that you want to split into different tables, for example, John Smith, 775 Westminster Avenue APT D5,Brooklyn, NY,11230, all of which I want to split into 4 tables and leave one home, where it will be only Name, Name and Address. The address to pull from these 4 tables to form one field, is it possible and how to do it?
April 7th 20 at 11:07
1 answer
April 7th 20 at 11:09
Solution
Possible. Use CONCAT and JOIN
But can you please give a minimal example, THANKS in advance! - jennyfer_Stiedemann2 commented on April 7th 20 at 11:12
A minimal example of the two tables:
SELECT
 CONCAT(person.name, ', ', address.name) AS person
FROM
person
LEFT JOIN address ON address.person_id = person.person_id
- Dereck commented on April 7th 20 at 11:15

Find more questions by tags MySQL