Fix experimental unequal join with subqueries in mixed join conditions

Fix (experimental) unequal join with subqueries for sets which are in the mixed join conditions. #64775 (lgbo).