Performing Set Operations with Lists

To join lists using AND or OR operations, or to subtract the contents of one list from another, choose Lists > Set Operations. The List Set Operations dialog opens. In the Left pane, select the list on the left side of the set operation. In the Right pane, select the list on the right side of the set operation. In the Destination pane, select the target list. Select the operation you want to perform in the Choose Operation drop-down and click OK.