Table of Contents
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 :