fix(optimizer): apply join transpose rule

fix(optimizer): apply join transpose rule #35921