Adding a Sub-query

CONNX Data Integration Suite 14.8.0 | InfoNaut - The Query Tool | Query Builder | Adding a Sub-query

Adding a Sub-query

There are two ways to add a sub query:

In the Columns Pane, right click on the Expression or Criteria columns and select Insert SubQuery from the drop-down menu.

Type (Select *) in the Expression column, and then type =(Select), In(Select), or any other valid sub-query expression in the Criteria column. Below is an example: In this example, the OrderDate object has (Select *) in the Expression field and =(Select) in the Criteria field.

In this example, the OrderDate object has (Select *) in the Expression field and =(Select) in the Criteria field.

CONNX creates a new sub-query tab.

You can switch to the sub-query tab to visually edit the sub-query the same way you edit the main query. There are two ways to switch to the sub-query tab:

Click the sub-query tab.

In the sub-query cell, click the ellipsis button. If the cell contains more than one sub-query, a drop-down menu appears. Select the sub-query you want.