CONCAT(
        add.street_number, ' ', tadd.street_name, ', ',
    -- concat() will return null if one is null, so ifnull returns empty string in that case
        IFNULL(CONCAT(tadd.apt_number, ', '), ''),
        tadd.city, ', ', tadd.postal_code, ', ',tadd.country
    ) AS 'Address'