Why Nesting is so Important
•You can enter any combination of logical operators in a single SELECT.
•
•Use parentheses as needed to specify the correct order of processing.
•
•Without parentheses, the order of processing  (for Dialog) is:
•
•First: NOT operators
•Second: AND operators
•Third: OR operators
•
Being able to combine concepts in a single select statement can be very helpful.  For example, we’ll soon learn about a tool that helps us scope out the number of records that match a particular query without actually searching every file.  The only problem is that our command mud