Oracle左外部联接查询 [英] Oracle left outer join query

问题描述

select a,last_note_user,c,d,iso_src
from X,Y,Z
left outer join W
ON (W.last_note_user=Z.userid AND W.user_ten=Y.iso_src)

当我执行上面的查询时，它给我错误"Y.iso_src" is a invalid identifier.但是，Y.iso_src是有效的标识符，它存在于系统表中. 上面的左外部联接有问题吗? 请帮帮我！！！

when I am executing the above query it is giving me the error "Y.iso_src" is a invalid identifier.However,Y.iso_src is a valid identifier and it exist in the system table. Is something wrong with the above left outer join?? Please help me out!!!

推荐答案

您不能以这种方式在Oracle中混合JOIN语法.

You cannot mix JOIN syntaxes in Oracle this way.

JOIN条件只能引用以前使用ANSI JOIN语法连接的表.

A JOIN condition can only refer tables previously joined using ANSI JOIN syntax.

使用此:

SELECT  a, last_note_user, c, d, iso_src
FROM    X
CROSS JOIN
        Y
CROSS JOIN
        Z
LEFT OUTER JOIN
        W
ON      W.last_note_user = Z.userid
        AND W.user_ten = Y.iso_src

这篇关于Oracle左外部联接查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！