-- This is a text query
SELECT Gene.name        AS ".GeneName",
       Translation.desc AS ".GeneDesc"
FROM   Gene, Translation, Region
WHERE  (Gene.geneId       = Translation.geneId) AND
       (Gene.regionId     = Region.regionId)    AND
       (Region.chromosome = ?)                  AND
       (Region.start     >= ?)                  AND
       (Region.end       <= (
        SELECT R.start
        FROM   Region R
        WHERE (R.regionId = "123")
       )