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