SELECT T2.address FROM store AS T1 JOIN address AS T2 ON T1.address_id  =  T2.address_id WHERE store_id  =  1
Return the address of store 1.
SELECT T2.address FROM store AS T1 JOIN address AS T2 ON T1.address_id = T2.address_id WHERE store_id = 1
select t2 . address from store as t1 join address as t2 on t1 . address_id = t2 . address_id where store_id = value
Return the address of store 1 .