When two or more tables are manipulated, duplicated data can be eliminated from retrieval results. UNION or DISTINCT specifies duplicated data elimination.

Figure 2-37 shows an example of duplicated data elimination. Here, the product codes of products (with at least 10 units ordered) are retrieved from two order tables, and duplicated data is eliminated.

Figure 2-37 Duplicated data elimination example