CREATE TABLE full_addreses_emils(
SELECT * FROM adrians_address_name
UNION 
SELECT * FROM address_name_eldars 
UNION
SELECT * FROM balajs_address_name
UNION
SELECT * FROM buls_address_name
UNION
SELECT * FROM cinkmanis_address_name
UNION
SELECT * FROM denis_address_name
UNION
SELECT * FROM dmitrijs_address_name
UNION
SELECT * FROM grinfelds_address_name
UNION
SELECT * FROM karklins_address_name
UNION
SELECT * FROM kaznovska_address_name
UNION
SELECT * FROM kemlers_address_name
UNION
SELECT * FROM lauris_address_name
UNION
SELECT * FROM skabardis_address_name
UNION
SELECT * FROM veide_address_name
UNION
SELECT * FROM zukovskis_address_name
UNION
SELECT * FROM aleksis_address_name
UNION
SELECT * FROM balajs_address_name
UNION
SELECT * FROM demidovs_address_name
UNION
SELECT * FROM grunde_address_name
UNION
SELECT * FROM kemlers_address_name
UNION
SELECT * FROM nazars_address_name
UNION
SELECT * FROM smits_address_name
UNION
SELECT * FROM kaznovska_address_name
UNION
SELECT * FROM glebs_address_name
UNION
SELECT * FROM address_name_eldars
UNION
SELECT * FROM address_name_guntars
UNION
SELECT * FROM andris_address_name
);