I have a query that produces a good plan and a bad plan

Erickson Winter 2017-10-04 23:34:23

Without query hints or plan guides, is there a way to force the good plan? It appears to be the way the QO joins the tables (table 1 can join to both 2 and 3, or t1 can join to t2, which joins to t3)