Where is store 1 located?
create table store (address_id varchar, PRIMARY KEY (address_id)); create table address (address varchar, address_id varchar, PRIMARY KEY (address))
select t2.address from store as t1 join address as t2 on t1.address_id = t2.address_id where store_id = 1