Child Alias 2
This child alias issues a SQL SELECT statement to retrieve address information for each customer that was returned in the parent alias's query. This alias can return more than one address, each of which will appear as documents within an ADDRESS document list in the results document.
Field | Value |
Alias Name | ADDRESS |
SQL | SELECT STREET FROM TABLE3 |
Relation | ID = CUSTOMER.ID |
Note that the relation field refers to the ID field in the parent alias name, not to the database table name. At run time the service will issue a SELECT statement as follows:
SELECT STREET FROM TABLE3 WHERE ID = valueFromParent