Parent Level Alias
This alias retrieves the customer's ID and name based on the customer's status. You will use the ID field from this alias to query the database in the two child aliases.
Field | Value |
Alias Name | CUSTOMERS |
SQL | SELECT NAME, ID FROM TABLE1 WHERE STATUS = ‘N' ORDER BY NAME |