Hi Richard Guo I see that the test samples are all (exists)subqueries ,I think semi join should also support ( in) and ( any)subqueries. would you do more test on ( in) and ( any) subqueries?
Best whish