Have I missed the concept of the question?

Select a.*, b.*, c.*...
FROM address a LEFT JOIN adinfo b
ON a.address_id = b.address id
LEFT JOIN adextra c
ON a.accress_id = c.adress_id
WHERE ...
INTO ...
ORDER BY ...