OPTION (FORCE ORDER)

This query hint tells the query execution engine to retrieve data in the same order as the tables are listed in the query; for example, after the FROM clause. Intermediate results for one table can be used to parameterize data retrieval of the next table. For example, it is advised to retrieve elements first to parameterize the attribute table or get attributes first in order to know what values should be retrieved.