1.         If we click on the SQL Tab we should see the following:

2.         The SQL tab might look a bit intimidating at first, because the fields have Exchange DASL complex schema names rather than the familiar Outlook field names. However, don’t be too concerned; the SQL queries are relatively easy to modify. While you can create power filters if you know some SQL syntax, you don't need to know a lot about SQL to create filters not possible using the other filter tabs.

3.         Note that Outlook has defaulted the second condition to an OR condition because this is the usual scenario in the case of fields that are the same. However in our case this will not work. Edit the criteria by clicking on Edit these criteria directly and change the expression to read:

4.         We then click OK to return to the Customize View screen. Then click OK to return to the Custom View Organizer, and Apply View to save and activate the view:

5.         All the Marketing Decision Makers that are located on the West Coast are displayed in the View – mission accomplished.