next up previous contents
Next: About this document Up: OPM Query Examples Previous: Query 6.

Query 7.

Retrieve all relevant attributes for all the elements of a particular map between two coordinates. 

SELECT ME(LFM_coord, RFM_coord, accessionID, coordinate, displayName,
       searchName, draw, point, segment, sortCoord, style, tier)
FROM ME IN MapElement, M IN ME.map
WHERE M.accessionID = "GDB:785407"
      AND ME.LFM_coord >= 10866
      AND (ME.coordinate != 10866 OR ME.point != "End" )
      AND ME.RFM_coord <= 1122
      AND (ME.coordinate != 1122 OR ME.point != "Start" )
ORDER BY ME.sortCoord;