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

Move "m_hasReceiveNode = true;" up to the top of this function as the default setting instead of repeating at every early return.