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:

command TABLENAME With clause And With clause

For example:

List CUSTOMERS With ST = 'CT' And With CITY = 'STAMFORD' 

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