ORACLE 子查询结果集 不能再当表用，报表或视图不存在

[k1263]

想请教一下，这里的 e ，为啥不能被语句 (SELECT COUNT() FROM e) t1, 里这么用？ 执行报错[42000][942] ORA-00942: 表或视图不存在 Position: 34 定位就是 (SELECT COUNT() FROM e) t1 的 e SELECT (SELECT COUNT() FROM e) t1, (SELECT COUNT() FROM JSSIE_DYZX.AC76 WHERE AAZ166 IN (SELECT AAZ166 FROM e)) t2, (SELECT COUNT() FROM JSSIE_DYZX.AC82 WHERE AAZ220 IN (SELECT AAZ220 FROM e)) t3, (SELECT COUNT() FROM JSSIE_DYZX.AC83 WHERE AAZ220 IN (SELECT AAZ220 FROM e)) t4 FROM ( SELECT AAZ166, AAZ220 FROM JSSIE_DYZX.AC75 WHERE AAZ002 IN ( SELECT AAZ002 FROM JSSIE_GI.AE02 WHERE AAA121 = 'I10032' AND AAA027 = '320621' AND AAE002 = 202306 AND AAE016 = '3' ) ) e;