Using And [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Using And ======

                                                                                                                                                                                                                                                       
The effect of using And between clauses is to narrow the range of rows selected. If clauses are connected with And, the rows to be selected must meet the criteria specified in every clause. For example, a command might contain logic like this:

<code>
command TABLENAME With clause And With clause
</code>


For example:

<code>
List CUSTOMERS With ST = 'CT' And With CITY = 'STAMFORD' 
</code>


Rows to be selected must meet the conditions specified in both With clauses.