oracle别名作用范围,在Oracle的Where子句子查询中使用别名或表名，

我需要在查询中显示其他表中的一些字段，我收到此错误：

ORA-00904：“THIS _” . “ID”：identificadorinválido00904 . 00000 - “％s：无效标识符”

这是查询

SELECT this_."ID" as ID1_47_2_

FROM "ENSAIO_AMOSTRA" this_

inner join "ETAPA_FLUXO_AMOSTRA" efe1_ on this_."ID" = efe1_."ID_ENSAIO_AMOSTRA"

inner join "ETAPA" et2_ on efe1_."ID_ETAPA"=et2_."ID"

WHERE et2_."ID" in (5) and not (et2_."ID" = 6)

and this_."ID_ENSAIO" = 835

and efe1_."ID" = (

select y0_ from

( SELECT this_0_."ID" as y0_

FROM "ETAPA_FLUXO_AMOSTRA" this_0_

WHERE this_0_."ID_ENSAIO_AMOSTRA" = this_."ID"

ORDER BY this_0_."ID" desc )

)

如果我为一个数字(已经存在的ensaio_amostra)改变了这个_ . “ID”，它就可以了 .

我该怎么办？