Where Clause property

The Where Clause property can only be filled for Table Selections of type Other Table. This where clause is added to the query of the session to join the data. Click Details to specify the where clause in the window.

Example:

        txprc001.pcod = tcibd001.cdf_pcod

This example shows how data from another table is joined to the main table tcibd001. As described earlier, ensure that the data in the joined table exists, otherwise the record of the main table is not visible in the session.