Query Defining the DISTS View

%entities; %constants; ]>

SELECT distances.distid AS distid
     , distances.intid AS intid
     , dpart1s.dpid AS dpart1pid
     , dpart2s.dpid AS dpart2pid
     , distances.uncertain AS uncertain
     , dpart1s.role AS dpart1role
     , dpart1s.participant AS participant1
     , dpart2s.role AS dpart2role
     , dpart2s.participant AS participant2
     , distances.distance AS distance
  FROM distances
         JOIN distanceparts AS dpart1s
           ON (dpart1s.distid = distances.distid)
         JOIN distanceparts AS dpart2s
           ON (dpart2s.distid = distances.distid)
  WHERE dpart1s.dpid <> dpart2s.dpid

;

Entity Relationship Diagram of the DISTS View If we could we would display here the diagram showing how the DISTS view is constructed.