高手指点: 有什么好办法?????
select po_order_b.pk_arrvstoorg pk_arrvstoorg,
po_order.cvendorbaseid cvendorbaseid,
bd_invbasdoc.pk_invcl pk_invcl,
po_order.vdef7 vdef7,
sum(po_order_b.nordernum) nordernum,
sum(po_order_b.naccumstorenum) naccumstorenum
from po_order_b po_order_b, po_order po_order, bd_invbasdoc bd_invbasdoc
where ((po_order_b.corderid in ('1001A810000000009QDS', '1001A810000000009QDW', '1001A810000000009QE0', '1001A810000000009QE8', '1001A810000000009QF8', '1001A810000000009QFC', '1001A810000000009QG1', '1001A810000000009QG5', , '1001A810000000009RP2', '1001A810000000009RRM', '1001A810000000009RRV', ...................................300个项
select po_order_b.pk_arrvstoorg pk_arrvstoorg,
po_order.cvendorbaseid cvendorbaseid,
bd_invbasdoc.pk_invcl pk_invcl,
po_order.vdef7 vdef7,
sum(po_order_b.nordernum) nordernum,
sum(po_order_b.naccumstorenum) naccumstorenum
from po_order_b po_order_b, po_order po_order, bd_invbasdoc bd_invbasdoc
where ((po_order_b.corderid in ('1001A810000000009QDS', '1001A810000000009QDW', '1001A810000000009QE0', '1001A810000000009QE8', '1001A810000000009QF8', '1001A810000000009QFC', '1001A810000000009QG1', '1001A810000000009QG5', , '1001A810000000009RP2', '1001A810000000009RRM', '1001A810000000009RRV', ...................................300个项
select po_order_b.pk_arrvstoorg pk_arrvstoorg,
po_order.cvendorbaseid cvendorbaseid,
bd_invbasdoc.pk_invcl pk_invcl,
po_order.vdef7 vdef7,
sum(po_order_b.nordernum) nordernum,
sum(po_order_b.naccumstorenum) naccumstorenum
from po_order_b po_order_b, po_order po_order, bd_invbasdoc bd_invbasdoc
where po_order_b.corderid in (select 临时字段 from 临时表)
po_order.cvendorbaseid cvendorbaseid,
bd_invbasdoc.pk_invcl pk_invcl,
po_order.vdef7 vdef7,
sum(po_order_b.nordernum) nordernum,
sum(po_order_b.naccumstorenum) naccumstorenum
from po_order_b po_order_b, po_order po_order, bd_invbasdoc bd_invbasdoc
where po_order_b.corderid exists (...)....
我的方法是把 id in ('1000','1001'...) 变成 where (id='1000' or id='1001' or .....)
'1001A810000000009QDS', '1001A810000000009QDW', '1001A810000000009QE0', '1001A810000000009QE8',
'1001A810000000009QF8', '1001A810000000009QFC', '1001A810000000009QG1', '1001A810000000009QG5',
'1001A810000000009RP2', '1001A810000000009RRM', '1001A810000000009RRV', 这些数据的特点吗?'1001A810000000009'都是一样的啊。你可以:
select po_order_b.pk_arrvstoorg pk_arrvstoorg,
po_order.cvendorbaseid cvendorbaseid,
bd_invbasdoc.pk_invcl pk_invcl,
po_order.vdef7 vdef7,
sum(po_order_b.nordernum) nordernum,
sum(po_order_b.naccumstorenum) naccumstorenum
from po_order_b po_order_b, po_order po_order, bd_invbasdoc bd_invbasdoc
where ((po_order_b.corderid like ('1001A810000000009_ _ _')