SELECT T2.premises_type ,  T1.address_type_code FROM customer_addresses AS T1 JOIN premises AS T2 ON T1.premise_id  =  T2.premise_id
Show the premise type and address type code for all customer addresses.
SELECT T2.premises_type , T1.address_type_code FROM customer_addresses AS T1 JOIN premises AS T2 ON T1.premise_id = T2.premise_id
select t2 . premises_type , t1 . address_type_code from customer_addresses as t1 join premises as t2 on t1 . premise_id = t2 . premise_id
Show the premise type and address type code for all customer addresses .