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
the SQL query. In the lower area, you will find the Query
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
arrow button below a column, the element
highlighted in the column will be inserted into the Query
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
Here you have the ability to search specifically for tables. To do so,
enter the search term into the Filter
then click on Search.