The SQL Server query optimizer processes a JOIN in the same order as the tables appear in the FROM clause, when FORCEPLAN is ON.
JOIN
FROM
FORCEPLAN
SET FORCEPLAN ON | OFF