Using AND and OR on Different Columns

Restriction: This topic applies to Windows environments only.

Values in different columns on the same row are treated as AND conditions. Values in different rows are treated as OR conditions. Look at the following Query Conditions Grid example.

This yields the following SELECT statement:

SELECT  E1.e_no, E1.lname, E1.payrate, E1.st, E1.com
FROM    TUTORIAL.TUTORIAL.EMPLOYEE E1
WHERE    ((E1.e_no Between 2 and 8) 
        OR (E1.lname like ""hur%"") 
        OR ((E1.payrate >4 
            AND E1.payrate < 15) 
            AND (E1.com is null)) 
            OR (E1.st <> "MD"))