You must follow three rules with unions:
• Each statement must consist of the same number of fields.
• Each statement must consist of the same data types.
• The field data types in each statement should correspond (be in the same order).
You do not have to use fields of like data type in one statement. That is, you can mix field data types within each statement as long as the data types correspond between the two statements.
In this topic, you will work with unions.
Table of Contents