执行报错[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;
