5.1.3 Intersection
The intersection of two tables contains the unique set of common rows shared by the two tables, ordered lexicographically. Only a single instance of each shared row is retained in the intersection table; all duplicates are removed. For information on how to create an intersection table, see Creating a Concatenated Table or the example below.
Assume that you want a list of only those customers who have purchased more than 100 pieces of both 'Wireless Mouse' and 'Fast Go Game'. This can be accomplished by taking the intersection of the 'Wireless Mouse' and 'Fast Go Game' queries.

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. Now select both the tables by holding down the Ctrl key and clicking on each table's title row.

6. Click on the 'Concatenate Table' button in the toolbar and select 'Intersect'. 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 (an intersect symbol in this case).

7. Preview the table 'Query1' by right-clicking on its title row and selecting 'Preview' from the context menu. The information for only those customers who purchased more than 100 pieces of both 'Wireless Mouse' and 'Fast Go Game' is included in the table.

| << 5.1.2 Union | © 1996-2013 InetSoft Technology Corporation (v11.4) | 5.1.4 Minus >> |