SELECT A.ORDER_ITEM_ID, A.DP_ORDER_ID, A.OFFER_INST_ID, A.OFFER_ID, A.OFFER_PKG_ID, A.OPERATION_TYPE
FROM DP_OFFER_ORDER A,ORDER_ITEM B,OFFER C
WHERE C.OFFER_ID = A.OFFER_ID
AND A.ORDER_ITEM_ID = B.ORDER_ITEM_ID
AND B.ORDER_STATE NOT IN ('E','C','M')
執行計劃
uj5u.com熱心網友回復:
這是笛卡兒積。統計資訊先收集下吧
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/54037.html
標籤:開發
