SQL-Where
Type
SQL Expression
Since
2.2.1
Description
With this property you can define a where condition for this link. Then this link will only be valid if the condition matches - this is known as conditional JOINs since SQL-92.
In order to use where conditions for JOINs they must be enabled for your database.
Examples
SQL-Where = "SALES.CUSTOMERTYPE = 1"
Could create a statement like:
SELECT ... FROM SALES INNER JOIN CUSTOMER ON ( SALES.CUSTOMER_ID = CUSTOMER.ID AND SALES.CUSTOMERTYPE = 1 )
