Query File (.qy)

Comments:

Each line is a query statement. A query statement can be a SQL statement or a set of TreeQ-VISTA constructed conditions. Different DB supports a slightly different set of SQL rules. The example below is provided for Derby. The first line is using TreeQ-VISTA constructed conditions and second line is a SQL statement for Derby.

Example:

TAXON.DOMAIN = Archaea, AND PHENOTYPECV.PHENOTYPE_TERM = Aerobe
SELECT * FROM TAXON WHERE TAXON.TAXON_OID < 1000

Also available:

SampleQueriesDerby.qy