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

The word "needs" in these names confused me. You really mean "has" ReceiveNode. One definition of "needs" is "does not have".