Re: How to convert subquery to table-join? Urgent!
From: minkanglu <minkanglu_at_doublebridge.com.cn>
Date: 7 Jan 2002 00:49:04 -0800
Message-ID: <4338e4b6.0201070049.189e47e4_at_posting.google.com>
Date: 7 Jan 2002 00:49:04 -0800
Message-ID: <4338e4b6.0201070049.189e47e4_at_posting.google.com>
I know in oracle maybe you can convert like this:
select a.IPAddress,b.NodeStatus
from NodeInSubnet a,TopoNode b
where a.NodeID=b.NodeID
minus
select a.IPAddress,b.NodeStatus
from NodeInSubnet a,TopoNode b,pollNodesInfo c
where a.NodeID=b.NodeID
and a.IPAddress=c.interfaceIP
and c.pollLevel in (0,1,2) and c.isChecked in(0,1)
minus
select a.IPAddress,b.NodeStatus
from NodeInSubnet a,TopoNode b,TopoIP c
where a.NodeID=b.NodeID and a.IPAddress=c.IPAddress
you can test. Received on Mon Jan 07 2002 - 09:49:04 CET