NAPIS® 'Step-by-Step' examples for SQL Usage

Example 1. The '=' Operator:

Query Builder To the top

Field Biomass Sample To the top

Example 2. The '>=' Operator:

Query Builder To the top

Biomass Sample Inventory To the top

Example 3. The 'and' Operator:

Query Builder To the top

Biomass Sample Inventory To the top

Example 4. The 'or' Operator (You must use parenthesis with the 'or' operator or you will create a Cartesian product!):

Query Builder To the top

Biomass Sample Inventory To the top

Example 5. The 'like' Operator:

Query Builder To the top

Biomass Sample Inventory To the top