CREATE TABLE TOURIST_ATTRACTIONS (Tourist_Attraction_ID VARCHAR2, How_to_Get_There VARCHAR2)
CREATE TABLE Street_Markets (Market_Details VARCHAR2, Market_ID VARCHAR2)

What are the details of the markets that can be accessed by walk or bus?
SELECT T1.Market_Details FROM Street_Markets AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Market_ID = T2.Tourist_Attraction_ID WHERE T2.How_to_Get_There = "walk" OR T2.How_to_Get_There = "bus"
SELECT "T1"."Market_Details" FROM "Street_Markets" "T1" JOIN "TOURIST_ATTRACTIONS" "T2" ON "T1"."Market_ID" = "T2"."Tourist_Attraction_ID" AND ("T2"."How_to_Get_There" = "bus" OR "T2"."How_to_Get_There" = "walk")