CREATE TABLE SHOPS (Shop_Details VARCHAR, Shop_ID VARCHAR)
CREATE TABLE TOURIST_ATTRACTIONS (Tourist_Attraction_ID VARCHAR, How_to_Get_There VARCHAR)

What are the details of the shops that can be accessed by walk?
SELECT T1.Shop_Details FROM SHOPS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Shop_ID = T2.Tourist_Attraction_ID WHERE T2.How_to_Get_There = "walk"
SELECT "T1"."Shop_Details" FROM "SHOPS" AS "T1" JOIN "TOURIST_ATTRACTIONS" AS "T2" ON "T1"."Shop_ID" = "T2"."Tourist_Attraction_ID" AND "T2"."How_to_Get_There" = "walk"