For example, the following query selects the order numbers of the orders placed by the customers who live in Paris. The ORDERS file and the CUSTOMER file are joined by the CustomerNum item. The join between these files is automatically defined by the query editor.
Note: The links between the files appear in the graphic representation of the query only if the two linked files are used by the query.
By default, the joins are automatically created by the query editor. However, these joins may not correspond to the requested result. Therefore, you have the ability to add or delete joins. These operations are described in the following paragraphs.
Adding a join into the current Select query
Deleting a join from the current Select query
Reinitializing the joins of the query
To reinitialize the joins of the current query:
To run queries with such joins, you must use H执行查询 or H执行SQL查询 associated with the h查询.无修正 constant.
SQL Server syntax for joins
To use the Oracle syntax:
J'accepte les termes de la licence
All you have to do is configure your product as follows: