1.
select a.bomcomponent,a.quantity,a.classtype,a.speprocuretypefbomitem from COC.MBOMITEM a where (materialbill, bomitemnodeno) in (select materialbill,bomitemnodeno
from COC.MBOMSITEMSELECT where materialbill='9166'
and (a.speprocuretypefbomitem <>'' or a.speprocuretypefbomitem is not null))
2.
select a.bomcomponent,a.quantity,a.classtype,a.speprocuretypefbomitem,bb.specprocuretype from COC.MBOMITEM a
join COC.PLANTMTL bb on a.bomcomponent=bb.mtlno
where (bb.specprocuretype <>'' or bb.specprocuretype is not null)
and (a.materialbill, a.bomitemnodeno) in (select materialbill,bomitemnodeno
from COC.MBOMSITEMSELECT where materialbill='9166') 最好可以给优化一下 我看着都晕了
select a.bomcomponent,a.quantity,a.classtype,a.speprocuretypefbomitem from COC.MBOMITEM a where (materialbill, bomitemnodeno) in (select materialbill,bomitemnodeno
from COC.MBOMSITEMSELECT where materialbill='9166'
and (a.speprocuretypefbomitem <>'' or a.speprocuretypefbomitem is not null))
2.
select a.bomcomponent,a.quantity,a.classtype,a.speprocuretypefbomitem,bb.specprocuretype from COC.MBOMITEM a
join COC.PLANTMTL bb on a.bomcomponent=bb.mtlno
where (bb.specprocuretype <>'' or bb.specprocuretype is not null)
and (a.materialbill, a.bomitemnodeno) in (select materialbill,bomitemnodeno
from COC.MBOMSITEMSELECT where materialbill='9166') 最好可以给优化一下 我看着都晕了
解决方案 »
- 语法应该没什么问题啊
- pl/sql存储过程里如何调用别的存储过程?
- ORACLE 10G SQLPLUS不输入主机字符串能连上,输入了就连不上了,请问什么原因?
- 请问各位大侠:在oci中,用C/C++怎样写入blob数据,我都费了2天了,一直没搞定。有现成的代码最好了,非常感谢:)
- 我在oracle中查询一个时间字段,只想得到它的年份.........
- 安装不了oracle 数据库客户端,怎么会事,咋办?
- 在update触发器中如何得到字段名?
- 关于数据库备份的问题
- 安装数据库问题
- 取记录集失败:用尽的Resultset!!!!这是怎么回事???help
- import导入数据用语句怎么写
- 一对多关系查询求和
SELECT a.bomcomponent, a.quantity, a.classtype, a.speprocuretypefbomitem
FROM coc.mbomitem a
WHERE (materialbill, bomitemnodeno) IN (
SELECT materialbill, bomitemnodeno
FROM coc.mbomsitemselect
WHERE materialbill = '9166'
AND ( a.speprocuretypefbomitem <> ''
OR a.speprocuretypefbomitem IS NOT NULL
))
2
SELECT a.bomcomponent, a.quantity, a.classtype, a.speprocuretypefbomitem,
bb.specprocuretype
FROM coc.mbomitem a JOIN coc.plantmtl bb ON a.bomcomponent = bb.mtlno
WHERE (bb.specprocuretype <> '' OR bb.specprocuretype IS NOT NULL)
AND (a.materialbill, a.bomitemnodeno) IN (
SELECT materialbill,
bomitemnodeno
FROM coc.mbomsitemselect
WHERE materialbill = '9166')
1用exist试试,不是绝对能快,但大部分时候能快
SELECT a.bomcomponent, a.quantity, a.classtype, a.speprocuretypefbomitem
FROM coc.mbomitem a
WHERE exists (
SELECT 1
FROM coc.mbomsitemselect b
WHERE materialbill = '9166'
AND ( a.speprocuretypefbomitem <> ''
OR a.speprocuretypefbomitem IS NOT NULL
) a.materialbill=b.materialbill and a.bomitemnodeno=a. bomitemnodeno
)
bb.specprocuretype
FROM coc.mbomitem a, coc.plantmtl bb
WHERE a.bomcomponent = bb.mtlno
AND (bb.specprocuretype <> '' OR bb.specprocuretype IS NOT NULL)
AND EXISTS (
SELECT 1
FROM coc.mbomsitemselect b
WHERE materialbill = '9166'
AND a.materialbill = b.materialbill
AND a.bomitemnodeno = b.bomitemnodeno)