Add guards for unsupported subqueries join plan, was too ambitious.

A top-level partitioned table scan is one case we need to be worried about, but shouldn't we also be worried about another partitioned subquery scan in the parent query?