What are the details and ways to get to tourist attractions related to royal family?
create table tourist_attractions (how_to_get_there varchar, tourist_attraction_id varchar, PRIMARY KEY (how_to_get_there)); create table royal_family (royal_family_details varchar, royal_family_id varchar, PRIMARY KEY (royal_family_details))
select t1.royal_family_details, t2.how_to_get_there from royal_family as t1 join tourist_attractions as t2 on t1.royal_family_id = t2.tourist_attraction_id