sql语句in 后面跟的数据过多怎么解决
高手指点: 有什么好办法?????
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个项