CREATE TABLE customer_addresses (address_id VARCHAR, customer_id VARCHAR)
CREATE TABLE addresses (address_details VARCHAR, address_id VARCHAR)

Return the address of customer 10.
SELECT T1.address_details FROM addresses AS T1 JOIN customer_addresses AS T2 ON T1.address_id = T2.address_id WHERE T2.customer_id = 10
SELECT "T1"."address_details" FROM "addresses" AS "T1" JOIN "customer_addresses" AS "T2" ON "T1"."address_id" = "T2"."address_id" AND "T2"."customer_id" = 10