SQL Developer“与连接图的其余部分断开连接” [英] SQL Developer "disconnected from the rest of the join graph"

问题描述

我有以下SQL：

select <misc things>
from pluspbillline 
left outer join workorder 
    on workorder.siteid=pluspbillline.siteid 
    and workorder.wonum = pluspbillline.refwo
    and workorder.orgid = pluspbillline.orgid
left outer join ticket
    on ticket.ticketid = pluspbillline.ticketid
    and ticket.class=pluspbillline.ticketclass
left outer join pluspsalesorder
    on pluspsalesorder.salesordernum=pluspbillline.salesordernum
    and pluspsalesorder.siteid=pluspbillline.siteid

在Oracle SQL Developer 4.0.0.13 （连接到一个DB2数据库），我在下面的斜体上看到一个波浪线：从 pluspbillline 和left outer join workorder 。

In Oracle SQL Developer 4.0.0.13 (connected to a DB2 database), I get a squiggly line underneath the following italics: "from pluspbillline" and "left outer join workorder".

警告说pluspbillline与连接图的其余部分断开连接。这是什么意思？

The warning says "pluspbillline is disconnected from the rest of the join graph". What does this mean?

推荐答案

我不知道是什么导致Oracle SQL Developer给出错误。但是我将此评论放在正确的格式下。

I'm not sure what's causing Oracle SQL Developer to give the error. But I'm putting this comment here to format it properly.

连接图可能看起来像这样

A join graph might look something like this

pluspbillline  ------+----<  workorder
                     |
                     +----<  ticket
                     |
                     +----<  pluspsalesorder

图表上的行可能标有连接字段。但这给了你一个基本的想法。

The lines on the graph might be labeled with the join fields. But this gives you a basic idea.

我没有看到任何你为什么收到这个警告的原因。 SQL中的列名称可能是打字错误？或者在Oracle的接口中有一些奇怪的是它不正确地理解DB2元数据？我建议尝试IBM的工具，看看它是否只是他们的程序。

I don't see any reason why you are getting this warning. A column name typo in your SQL perhaps? Or some quirk in Oracle's interface that it doesn't understand the DB2 metadata properly? I suggested trying IBM's tool to see if it's merely their program.

这篇关于SQL Developer“与连接图的其余部分断开连接”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！