====== Table and subquery selection ======
===== Choice of tables =====

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200710-100643.png?nolink&500}}

<WRAP round tip> 
The same table can be added several times. An index (_1, _2, _3...) allows distinguishing the different occurrences. </WRAP>

Ex: \\ 
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200710-100940.png?nolink}}

You can also customize the Table Name by using the **F2 key**.

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200710-101027.png?nolink}}

===== Selection of Queries =====

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200710-101320.png?nolink&500}}

<WRAP round important> You can only add a subquery that :

  * if it relates to the same data source as the calling query.
  * if it is available in the user's directory.

To use a published query as a subquery, you must create a copy of it in the user's folder. </WRAP>

The magnifying glass gives an overview of the request called :

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200710-101601.png?nolink&480}}

If you check the box in front of the name of a subquery, it is **incorporated** into the query you are building: a **frozen copy** of the subquery called is stored in the query you are building.

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200710-101751.png?nolink}}

If you leave the checkbox unchecked, you keep a dynamic link with the query called.

<WRAP round important> The publication of a query necessarily incorporates subqueries. </WRAP>

When a query is embedded, it can be extracted into the user's directory.

{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-154355.png?nolink&}}

<WRAP round tip> You can add the same subquery several times. An index (:1, :2, :3...) allows us to distinguish the different occurrences. </WRAP>

{{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200629-150646.png?nolink&}}