The select mode used to join tables in a query.
For EACH all records from the child table are returned.
For FIRST only the first record from the child table are returned.
For LAST only the last record from the child table are returned.
The select mode used to join tables in a query.