5.1.4 Minus
The difference (minus) of two tables is the set of distinct rows found in one table but not in the other. The first table selected is the table whose unique rows are retained in the result. For information on how to create a Minus table, see the Creating a Concatenated Table section or the example below.
Assume you want a list of all the customers who purchased more than 100 pieces of 'Fast Go Game' but did not purchase more than 100 pieces of 'Wireless Mouse'. Follow these steps to accomplish that result.

1. Create a new Worksheet by clicking on the 'New Worksheet' button.
2. Expand the 'Data Source' node, the 'Orders' node, and the 'DWS' node.
3. Drag the 'Fast Go Game' node from the tree to an empty cell in the Worksheet. A new table named 'Fast Go Game1' is created.
4. Drag the 'Wireless Mouse' node from the tree to an empty cell in the Worksheet. A new table named 'Wireless Mouse1' is created.

5. First select the 'Fast Go Game1' table by clicking the table's title bar.
6. Now select the 'Wireless Mouse1' table as well by Ctrl-clicking the table's title bar (It is important to select the 'Wireless Mouse1' table after selecting the 'Fast Go Game1' table.)

7. Click on the 'Concatenate Table' button, and select 'Minus'. A new table, 'Query1', is created. Notice that the title row includes the names of the tables participating in the concatenation and the type of concatenation (a minus symbol in this case).

8. Preview the table 'Query1' by right-clicking on its title row and selecting 'Preview' from the context menu. The information for all customers who purchased more than 100 pieces of 'Fast Go Game' but did not purchase more than 100 pieces of 'Wireless Mouse' is included in the table.

| << 5.1.3 Intersect | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.1.5 Changing the Concatenation Type >> |