Retrieve attributes of all Linkage and Cytogenetic Maps containing MapElements associated with GenomicSegments CFTR and DMD.
SELECT M(displayName, accessionID, units, objectClass, minCoord, maxCoord)
FROM M IN Map,
GS1 IN M.!map[MapElement]segment[GenomicSegment]!dBObject[ObjectName]searchName,
GS2 IN M.!map[MapElement]segment[GenomicSegment]!dBObject[ObjectName]searchName,
OC IN M.objectClass
WHERE GS1 ="cftr" AND GS2 ="dmd"
AND OC IN { "string", "LinkageMap", "CytogeneticMap" }
ORDER BY M.displayName;
The comment for query 2 above also applies to query 3.