我需要在查詢中顯示其他表中的一些字段，我收到此錯誤：

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”，它就可以了 .

我該怎么辦？

總結

以上是生活随笔為你收集整理的oracle别名作用范围,在Oracle的Where子句子查询中使用别名或表名，的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。