SQL Target Query

If data is to be accepted after filtering, you can formulate a statement here. You can then assign the query result as usual in the field assignment to a target data field.

In the upper area of the dialog, enter the Name of the SQL query. In the lower area, you will find the Query field. Database tables, fields, and the source fields for the comparison can be selected in the three columns above the query field. If you click on the arrow button below a column, the element highlighted in the column will be inserted into the Query field. When formulating the query, please take care to use the correct syntax depending on the database.

In the Tables for query in target column, you will find the Search tab.

Here you have the ability to search specifically for tables. To do so, enter the search term into the Filter field and then click on Search.