meta data for this page

UNION query

Usage

This type of query is similar to the SQL UNION function. These queries are used to display the rows extractedby two (or more) subqueries.

Difference from query

Selecting Subqueries

As for the matching], at [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables|data source selection, no table can be selected, only queries.

All subqueries must use the same data source as the one selected in the union query.

Vigilens checks that the structures of the subqueries are consistent with each other, i.e. :

  • they have the same number of fields
  • the field types (in the order they appear) are identical

Screens out

The following screens of the inquiry are absent when creating a UNION :