Combining Statements.

In many instances, it is useful to combine more than one statement to do more complex querying. For example, let say that you wanted to find all locations in a cave where the pH exceed six and there was also calcite. This would require two statements:

Two Statement Boxes. The Query Builder has two Statement Boxes that allow you to combine two statements into a single query. You simply put one query in each box and the Query Builder will combine the two statements.

Combining Statements. The two statements are combined using what is called a "boolean" operator. There are two basic Boolean operators: "And" and "Or". The "And" operator combines the two statements so that both of them must be true before the database returns a particular row. The "Or" operator combines the two statements so that either statement can be true and the database will return the row.

Once you have created a query, turn to the "Do Query" page to use the query and the data.