SELECT t1.* FROM Table1 t1 STRAIGHT_JOIN Table2 t2 ON t1.CommonID = t2.CommonID WHERE t1.FilterID = 1