Differences

This shows you the differences between two versions of the page.

--- en:v8_0_0:designer:menus:accueil:nouvellerequete:union [2020/09/10 16:53]
sylvainr [Selecting Subqueries]
+++ en:v8_0_0:designer:menus:accueil:nouvellerequete:union [2020/09/10 16:55] (current)
sylvainr [Screens out]
@@ Line 8: / Line 8: @@
 ==== Selecting Subqueries ====
-As for the [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:rapprochement|matching]],
+As for the [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:rapprochement|matching], at [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables|data source selection]], no table can be selected, only queries.
-At the time of [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:choixtables|data source selection]], no table can be selected, only queries.
 {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200625-144813.png?nolink&500}}
+<WRAP round important>
+All subqueries must use the same data source as the one selected in the union query.
+</WRAP>
+<WRAP round alert>
+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
+</WRAP>
 ==== Screens out ====
@@ Line 20: / Line 29: @@
   * [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation#annexes|Appendices screen.]]
   * [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:consultation#decimales_devises|Currency decimal screen]]