Add guards for unsupported subqueries join plan, optimize the possible subqueriese

Simplify "For some subquery, it can only join with partition table" --> "Some subquery results can only be joined with a partitioned table"
Spelling "thoese"--> "those".