Create a Union Query
- To create a union Query right click on the Diagram Pane and select Union.
- Select New union sub-query .
- Select the left Q .
- Drop the table / view or Report Object to the Diagram pane.
- Select fields to be queried.
- Select the right Q .
- Drop the table / view or Report Object to the Diagram pane.
- Select fields to be queried.
- Click on the Union symbol and select the union type.