Understanding Unions



  1. You use unions to combine records that have no fields in common and to retrieve similar data from unrelated records in one query, as shown in this example.

    Step 1
  2. This table lists the features and their meanings that you should note about unions.

    Step 2
  3. Literals are placeholders, or pieces of text. Literals are useful when you create complex unions.


    When you create a union, both queries must have the same number of fields, but the fields don’t have to be identical. Therefore, applying literals as placeholder fields is useful.


    This is the process of creating literal.

    Step 3
  4. This is the process of creating a union.

    Step 4

You have successfully reviewed the Understanding Unions topic.

Table of Contents  Start Topic