begin %basic% CREATE_VIEW Query6 SELECT loc1.name, loc2.name, tl.t FROM shortestpath as tl, location_Info as loc1, location_Info as loc2 WHERE tl.x=loc1.id, tl.y=loc2.id, loc1.name="Nutty_Barn", loc2.name="DJ_Drew_Dungeon" end %basic%