Is it possible to form a field from several links to other tables?

Question

MySQL

There is an address field that needs to be split into different tables, for example, John Smith, 775 Westminster Avenue APT D5, Brooklyn, NY, 11230, I want to split all this into 4 tables and leave one main one, where there will be only First Name Last Name and Address. Pull the address itself from these 4 tables and form one field, is it possible and how can this be done?

Answer 1

Maybe. Use CONCAT and JOIN