当前Doris支持Where 和 Join 子句中的子查询:子查询; 可以参考这个帖子:https://ask.selectdb.com/questions/D1nH1/select-zhong-zhi-chi-zi-cha-xun-de-gong-neng-shen-me-shi-hou-ke-yi-ti-gong-zhi-chi/E1XH1