一条查不出结果的SELECT语句

第一条：
Select Distinct kwereport.f_etd(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'CNSHA') As ETD, 
       kwereport.f_atd(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*') As ATD, 
       kwereport.f_eta(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'CNSHA') As ETA, 
       kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*') As ATA, 
       cws.MWB As MAWB, kwereport.f_MAWBPieces(cws.MWB,cws.TRANSPORT_MODE,'MAWBPieces') as MAWBPieces, 
       kwereport.f_MAWBPieces(cws.MWB,cws.TRANSPORT_MODE,'MAWBContainer') as MAWBContainerType, 
       cws.HWB_STATUS, 
       cws.HWB_TYPE, 
       kwereport.f_TEU(cws.MWB) as TEU, 
       cws.HWB As HAWB, 
       cws.AGENT_TYPE As AgentType, 
       cws.CLASS_A_AGENT As ClassAAgentAgent, 
       cws.ORIGIN_TRAFFIC_CONFERENCE As RegionOrigin, 
       cws.ORIGIN_COUNTRY As CountryOrigin, 
       cws.ORIGIN_CITY As CityOrigin, 
       kwereport.f_portorigin(cws.HWB) As PortOrigin , 
       cws.DEST_TRAFFIC_CONFERENCE As RegionDestination, 
       cws.DEST_COUNTRY As CountryDestination, 
       cws.DEST_CITY As CityDestination, 
       kwereport.f_portdest(cws.HWB,cws.BUSINESS_TYPE) As PortDestination, 
       cws.PLACE_OF_DELIVERY As PlaceOfDelivery, 
       cws.IMP_C_C_POINT As ImportCCPoint, 
       cws.SHIPPER_SHORT_NAME As Shipper, 
       cws.SHIPPER_NAME As ShipperName, 
       cws.CONSIGNEE_SHORT_NAME As Consignee, 
       cws.CONSIGNEE_NAME As ConsigneeName, 
       cws.NOTIFY_NAME As NotifyName, 
       cws.SERVICE_TYPE As ServiceType, 
       cws.CS_NAME As CS, 
       cws.SALES_PERSON As SALES, 
       cws.ORIGIN_CITY As DEPARTURE, 
       cws.CARRIER, kwereport.f_FLT(cws.HWB,cws.BUSINESS_TYPE,'CNSHA','*') As FLT, 
       kwereport.f_VesselVoyage(cws.MWB,'name',cws.BUSINESS_TYPE,'CNSHA','*') As VesselName, 
       kwereport.f_VesselVoyage(cws.MWB,'no',cws.BUSINESS_TYPE,'CNSHA','*') As VoyageNo, 
       cws.SETTLEMENT_AGENT_NAME As DestinationAgent, 
       cws.ISSUE_DATE As ISSUEDATE, 
       cws.CREATED_BY As CreatedBy, 
       kwereport.f_freehouse(cws.HWB) As FREEHOUSE,
       kwereport.f_freighterm(cws.HWB) As FreightTerms, 
       cws.GROSS_WT_IN_TOTAL_GRP_BOX As GrossWt, 
       cws.GROSS_WT_UOM_IN_TOTAL_GRP_BOX As GrossWtUOM, 
       cws.VOL_WT_IN_TOTAL_GRP_BOX As VolumeWt, 
       cws.VOL_WT_UOM_IN_TOTAL_GRP_BOX As VolumeWtUOM, 
       cws.VOL_IN_TOTAL_GRP_BOX As Volume, 
       cws.VOL_UOM_IN_TOTAL_GRP_BOX As VolumeUOM, 
       cws.CHGBLE_WT_IN_TOTAL_GRP_BOX As ChargeableWt,
       cws.CHGBLE_WT_UOM_IN_TOTAL_GRP_BOX As ChargeableWtUOM, 
       cws.TOTAL_PCS_IN_TOTAL_GRP_BOX As PIECES_air, 
       kwereport.f_piecesocean(cws.HWB) As PIECES_ocean, 
       cws.PKG_TYPE_IN_TOTAL_GRP_BOX As PACKAGE_air, 
       kwereport.f_packageocean(cws.HWB) As PACKAGE_ocean, 
       cws.DEPOSITION As Deposition, 
       cws.PORT_OF_LOADING As PortofLoading, 
       cws.PORT_OF_UNLOADING As PortofUnloading, 
       cws.FINAL_DEST As FinalDestination, 
       cws.CUST_BOOKING_NO As CustomerBookingNumber, 
       cws.STORAGE_DAYS As InboundDate, 
       ds.DESPATCHED_DATE As DeliveryDate, 
       cws.PLACE_OF_DELIVERY_ETA As OutboundDate, 
       ds.POD As POD, 
       ds.PICKUP_FROM_NAME As PickupFromName, 
       cws.LOCATION_OF_FREIGHT_NAME As TerminalName, 
       dd.DESCR As DESCRIPTION1, 
       kwereport.f_comment(cws.HWB) As LOCATION1, 
       kwereport2.f_re(cws.HWB) as Re, 
       kwereport2.f_PIN(cws.HWB) as PurchaseInvcoieNo, 
       kwereport.f_totalfee(cws.HWB) As TOTALFEE_CNY, 
       kwereport.f_totalcost(cws.HWB) As TOTALCOST_CNY, 
       kwereport.f_waybillamt(cws.HWB,'FRTRV','freight') As FreightAmount_AE,
       kwereport.f_waybillamt(cws.HWB,'FRTRV','freightCurr') As FreightCurrency_AE, 
       kwereport.f_waybillamt(cws.HWB,'FRTRV','rate') As FreightRate_AE, 
       kwereport.f_waybillamt(cws.HWB,'FRTRV','other') As OtherChargeCNY_AE, 
       kwereport.f_waybillamt(cws.HWB,'OFRV','freight') As FreightAmount_OE, 
       kwereport.f_waybillamt(cws.HWB,'OFRV','freightCurr') As FreightCurrency_OE, 
       kwereport.f_waybillamt(cws.HWB,'OFRV','rate') As FreightRate_OE, 
       kwereport.f_waybillamt(cws.HWB,'OFRV','other') As OtherChargeCNY_OE, 
       kwereport.f_waybillamt(cws.HWB,'FCFAD','freight') As FreightAmount_AI_OI, 
       kwereport.f_waybillamt(cws.HWB,'FCFAD','freightCurr') As FreightCurrency_AI_OI, 
       kwereport.f_waybillamt(cws.HWB,'FCFAD','other') As OtherChargeCNY_AI_OI, 
       kwereport2.f_chargecode_amt(cws.HWB,cws.BUSINESS_TYPE,cws.TRANSPORT_MODE) As charge_amt, 
       kwereport2.f_chargecode_cost(cws.HWB,cws.BUSINESS_TYPE,cws.TRANSPORT_MODE) As charge_cost 
From  HWB_SUMMARY cws 
      Left Join HWB_CHARGE cwc On cws.HWB=cwc.HWB 
      Left Join HWB_DETAIL cwd On cws.HWB=cwd.HWB 
      Left Join DEL_DETAIL dd On cws.HWB=dd.HWB 
      Left Join DEL_SUMMARY ds On dd.DELIVERY_INSTRUCTION_NO=ds.DELIVERY_INSTRUCTION_NO 
Where cws.COMPANY='510' and cws.TERMINAL='5101' 
and cws.TRANSPORT_MODE='Air' and cws.BUSINESS_TYPE='Import' 
and kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*')>=to_date('2006-2-1','yyyy-mm-dd') 
and kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*')<to_date('2006-3-1','yyyy-mm-dd')
and kwereport.f_portdest(cws.HWB,cws.BUSINESS_TYPE)='PVG'

解决方案 »

  1.   

    第二条：（跟上一条一模一样，只是多加了一个限制条件cws.HWB_STATUS='O'）
    Select Distinct kwereport.f_etd(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'CNSHA') As ETD, 
           kwereport.f_atd(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*') As ATD, 
           kwereport.f_eta(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'CNSHA') As ETA, 
           kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*') As ATA, 
           cws.MWB As MAWB, kwereport.f_MAWBPieces(cws.MWB,cws.TRANSPORT_MODE,'MAWBPieces') as MAWBPieces, 
           kwereport.f_MAWBPieces(cws.MWB,cws.TRANSPORT_MODE,'MAWBContainer') as MAWBContainerType, 
           cws.HWB_STATUS, 
           cws.HWB_TYPE, 
           kwereport.f_TEU(cws.MWB) as TEU, 
           cws.HWB As HAWB, 
           cws.AGENT_TYPE As AgentType, 
           cws.CLASS_A_AGENT As ClassAAgentAgent, 
           cws.ORIGIN_TRAFFIC_CONFERENCE As RegionOrigin, 
           cws.ORIGIN_COUNTRY As CountryOrigin, 
           cws.ORIGIN_CITY As CityOrigin, 
           kwereport.f_portorigin(cws.HWB) As PortOrigin , 
           cws.DEST_TRAFFIC_CONFERENCE As RegionDestination, 
           cws.DEST_COUNTRY As CountryDestination, 
           cws.DEST_CITY As CityDestination, 
           kwereport.f_portdest(cws.HWB,cws.BUSINESS_TYPE) As PortDestination, 
           cws.PLACE_OF_DELIVERY As PlaceOfDelivery, 
           cws.IMP_C_C_POINT As ImportCCPoint, 
           cws.SHIPPER_SHORT_NAME As Shipper, 
           cws.SHIPPER_NAME As ShipperName, 
           cws.CONSIGNEE_SHORT_NAME As Consignee, 
           cws.CONSIGNEE_NAME As ConsigneeName, 
           cws.NOTIFY_NAME As NotifyName, 
           cws.SERVICE_TYPE As ServiceType, 
           cws.CS_NAME As CS, 
           cws.SALES_PERSON As SALES, 
           cws.ORIGIN_CITY As DEPARTURE, 
           cws.CARRIER, kwereport.f_FLT(cws.HWB,cws.BUSINESS_TYPE,'CNSHA','*') As FLT, 
           kwereport.f_VesselVoyage(cws.MWB,'name',cws.BUSINESS_TYPE,'CNSHA','*') As VesselName, 
           kwereport.f_VesselVoyage(cws.MWB,'no',cws.BUSINESS_TYPE,'CNSHA','*') As VoyageNo, 
           cws.SETTLEMENT_AGENT_NAME As DestinationAgent, 
           cws.ISSUE_DATE As ISSUEDATE, 
           cws.CREATED_BY As CreatedBy, 
           kwereport.f_freehouse(cws.HWB) As FREEHOUSE,
           kwereport.f_freighterm(cws.HWB) As FreightTerms, 
           cws.GROSS_WT_IN_TOTAL_GRP_BOX As GrossWt, 
           cws.GROSS_WT_UOM_IN_TOTAL_GRP_BOX As GrossWtUOM, 
           cws.VOL_WT_IN_TOTAL_GRP_BOX As VolumeWt, 
           cws.VOL_WT_UOM_IN_TOTAL_GRP_BOX As VolumeWtUOM, 
           cws.VOL_IN_TOTAL_GRP_BOX As Volume, 
           cws.VOL_UOM_IN_TOTAL_GRP_BOX As VolumeUOM, 
           cws.CHGBLE_WT_IN_TOTAL_GRP_BOX As ChargeableWt,
           cws.CHGBLE_WT_UOM_IN_TOTAL_GRP_BOX As ChargeableWtUOM, 
           cws.TOTAL_PCS_IN_TOTAL_GRP_BOX As PIECES_air, 
           kwereport.f_piecesocean(cws.HWB) As PIECES_ocean, 
           cws.PKG_TYPE_IN_TOTAL_GRP_BOX As PACKAGE_air, 
           kwereport.f_packageocean(cws.HWB) As PACKAGE_ocean, 
           cws.DEPOSITION As Deposition, 
           cws.PORT_OF_LOADING As PortofLoading, 
           cws.PORT_OF_UNLOADING As PortofUnloading, 
           cws.FINAL_DEST As FinalDestination, 
           cws.CUST_BOOKING_NO As CustomerBookingNumber, 
           cws.STORAGE_DAYS As InboundDate, 
           ds.DESPATCHED_DATE As DeliveryDate, 
           cws.PLACE_OF_DELIVERY_ETA As OutboundDate, 
           ds.POD As POD, 
           ds.PICKUP_FROM_NAME As PickupFromName, 
           cws.LOCATION_OF_FREIGHT_NAME As TerminalName, 
           dd.DESCR As DESCRIPTION1, 
           kwereport.f_comment(cws.HWB) As LOCATION1, 
           kwereport2.f_re(cws.HWB) as Re, 
           kwereport2.f_PIN(cws.HWB) as PurchaseInvcoieNo, 
           kwereport.f_totalfee(cws.HWB) As TOTALFEE_CNY, 
           kwereport.f_totalcost(cws.HWB) As TOTALCOST_CNY, 
           kwereport.f_waybillamt(cws.HWB,'FRTRV','freight') As FreightAmount_AE,
           kwereport.f_waybillamt(cws.HWB,'FRTRV','freightCurr') As FreightCurrency_AE, 
           kwereport.f_waybillamt(cws.HWB,'FRTRV','rate') As FreightRate_AE, 
           kwereport.f_waybillamt(cws.HWB,'FRTRV','other') As OtherChargeCNY_AE, 
           kwereport.f_waybillamt(cws.HWB,'OFRV','freight') As FreightAmount_OE, 
           kwereport.f_waybillamt(cws.HWB,'OFRV','freightCurr') As FreightCurrency_OE, 
           kwereport.f_waybillamt(cws.HWB,'OFRV','rate') As FreightRate_OE, 
           kwereport.f_waybillamt(cws.HWB,'OFRV','other') As OtherChargeCNY_OE, 
           kwereport.f_waybillamt(cws.HWB,'FCFAD','freight') As FreightAmount_AI_OI, 
           kwereport.f_waybillamt(cws.HWB,'FCFAD','freightCurr') As FreightCurrency_AI_OI, 
           kwereport.f_waybillamt(cws.HWB,'FCFAD','other') As OtherChargeCNY_AI_OI, 
           kwereport2.f_chargecode_amt(cws.HWB,cws.BUSINESS_TYPE,cws.TRANSPORT_MODE) As charge_amt, 
           kwereport2.f_chargecode_cost(cws.HWB,cws.BUSINESS_TYPE,cws.TRANSPORT_MODE) As charge_cost 
    From  HWB_SUMMARY cws 
          Left Join HWB_CHARGE cwc On cws.HWB=cwc.HWB 
          Left Join HWB_DETAIL cwd On cws.HWB=cwd.HWB 
          Left Join DEL_DETAIL dd On cws.HWB=dd.HWB 
          Left Join DEL_SUMMARY ds On dd.DELIVERY_INSTRUCTION_NO=ds.DELIVERY_INSTRUCTION_NO 
    Where cws.COMPANY='510' and cws.TERMINAL='5101' 
    and cws.TRANSPORT_MODE='Air' and cws.BUSINESS_TYPE='Import' 
    and cws.HWB_STATUS='O'
    and kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*')>=to_date('2006-2-1','yyyy-mm-dd') 
    and kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*')<to_date('2006-3-1','yyyy-mm-dd')
    and kwereport.f_portdest(cws.HWB,cws.BUSINESS_TYPE)='PVG' 结果第二条竟然能搜索出来一条记录，第一条反倒一条也搜不出来……为什么啊？！！
      

  2.   

    第三条：（跟前面一样，多加了限制条件(cws.HWB_STATUS='O' Or cws.HWB_STATUS='OI' Or cws.HWB_STATUS='C' Or cws.HWB_STATUS='CAN' Or cws.HWB_STATUS='CNF' Or cws.HWB_STATUS='ICF' or cws.HWB_STATUS='IS' Or cws.HWB_STATUS='OIE')，结果也搜索不出任何记录……
    －－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
    Select Distinct kwereport.f_etd(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'CNSHA') As ETD, 
           kwereport.f_atd(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*') As ATD, 
           kwereport.f_eta(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'CNSHA') As ETA, 
           kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*') As ATA, 
           cws.MWB As MAWB, kwereport.f_MAWBPieces(cws.MWB,cws.TRANSPORT_MODE,'MAWBPieces') as MAWBPieces, 
           kwereport.f_MAWBPieces(cws.MWB,cws.TRANSPORT_MODE,'MAWBContainer') as MAWBContainerType, 
           cws.HWB_STATUS, 
           cws.HWB_TYPE, 
           kwereport.f_TEU(cws.MWB) as TEU, 
           cws.HWB As HAWB, 
           cws.AGENT_TYPE As AgentType, 
           cws.CLASS_A_AGENT As ClassAAgentAgent, 
           cws.ORIGIN_TRAFFIC_CONFERENCE As RegionOrigin, 
           cws.ORIGIN_COUNTRY As CountryOrigin, 
           cws.ORIGIN_CITY As CityOrigin, 
           kwereport.f_portorigin(cws.HWB) As PortOrigin , 
           cws.DEST_TRAFFIC_CONFERENCE As RegionDestination, 
           cws.DEST_COUNTRY As CountryDestination, 
           cws.DEST_CITY As CityDestination, 
           kwereport.f_portdest(cws.HWB,cws.BUSINESS_TYPE) As PortDestination, 
           cws.PLACE_OF_DELIVERY As PlaceOfDelivery, 
           cws.IMP_C_C_POINT As ImportCCPoint, 
           cws.SHIPPER_SHORT_NAME As Shipper, 
           cws.SHIPPER_NAME As ShipperName, 
           cws.CONSIGNEE_SHORT_NAME As Consignee, 
           cws.CONSIGNEE_NAME As ConsigneeName, 
           cws.NOTIFY_NAME As NotifyName, 
           cws.SERVICE_TYPE As ServiceType, 
           cws.CS_NAME As CS, 
           cws.SALES_PERSON As SALES, 
           cws.ORIGIN_CITY As DEPARTURE, 
           cws.CARRIER, kwereport.f_FLT(cws.HWB,cws.BUSINESS_TYPE,'CNSHA','*') As FLT, 
           kwereport.f_VesselVoyage(cws.MWB,'name',cws.BUSINESS_TYPE,'CNSHA','*') As VesselName, 
           kwereport.f_VesselVoyage(cws.MWB,'no',cws.BUSINESS_TYPE,'CNSHA','*') As VoyageNo, 
           cws.SETTLEMENT_AGENT_NAME As DestinationAgent, 
           cws.ISSUE_DATE As ISSUEDATE, 
           cws.CREATED_BY As CreatedBy, 
           kwereport.f_freehouse(cws.HWB) As FREEHOUSE,
           kwereport.f_freighterm(cws.HWB) As FreightTerms, 
           cws.GROSS_WT_IN_TOTAL_GRP_BOX As GrossWt, 
           cws.GROSS_WT_UOM_IN_TOTAL_GRP_BOX As GrossWtUOM, 
           cws.VOL_WT_IN_TOTAL_GRP_BOX As VolumeWt, 
           cws.VOL_WT_UOM_IN_TOTAL_GRP_BOX As VolumeWtUOM, 
           cws.VOL_IN_TOTAL_GRP_BOX As Volume, 
           cws.VOL_UOM_IN_TOTAL_GRP_BOX As VolumeUOM, 
           cws.CHGBLE_WT_IN_TOTAL_GRP_BOX As ChargeableWt,
           cws.CHGBLE_WT_UOM_IN_TOTAL_GRP_BOX As ChargeableWtUOM, 
           cws.TOTAL_PCS_IN_TOTAL_GRP_BOX As PIECES_air, 
           kwereport.f_piecesocean(cws.HWB) As PIECES_ocean, 
           cws.PKG_TYPE_IN_TOTAL_GRP_BOX As PACKAGE_air, 
           kwereport.f_packageocean(cws.HWB) As PACKAGE_ocean, 
           cws.DEPOSITION As Deposition, 
           cws.PORT_OF_LOADING As PortofLoading, 
           cws.PORT_OF_UNLOADING As PortofUnloading, 
           cws.FINAL_DEST As FinalDestination, 
           cws.CUST_BOOKING_NO As CustomerBookingNumber, 
           cws.STORAGE_DAYS As InboundDate, 
           ds.DESPATCHED_DATE As DeliveryDate, 
           cws.PLACE_OF_DELIVERY_ETA As OutboundDate, 
           ds.POD As POD, 
           ds.PICKUP_FROM_NAME As PickupFromName, 
           cws.LOCATION_OF_FREIGHT_NAME As TerminalName, 
           dd.DESCR As DESCRIPTION1, 
           kwereport.f_comment(cws.HWB) As LOCATION1, 
           kwereport2.f_re(cws.HWB) as Re, 
           kwereport2.f_PIN(cws.HWB) as PurchaseInvcoieNo, 
           kwereport.f_totalfee(cws.HWB) As TOTALFEE_CNY, 
           kwereport.f_totalcost(cws.HWB) As TOTALCOST_CNY, 
           kwereport.f_waybillamt(cws.HWB,'FRTRV','freight') As FreightAmount_AE,
           kwereport.f_waybillamt(cws.HWB,'FRTRV','freightCurr') As FreightCurrency_AE, 
           kwereport.f_waybillamt(cws.HWB,'FRTRV','rate') As FreightRate_AE, 
           kwereport.f_waybillamt(cws.HWB,'FRTRV','other') As OtherChargeCNY_AE, 
           kwereport.f_waybillamt(cws.HWB,'OFRV','freight') As FreightAmount_OE, 
           kwereport.f_waybillamt(cws.HWB,'OFRV','freightCurr') As FreightCurrency_OE, 
           kwereport.f_waybillamt(cws.HWB,'OFRV','rate') As FreightRate_OE, 
           kwereport.f_waybillamt(cws.HWB,'OFRV','other') As OtherChargeCNY_OE, 
           kwereport.f_waybillamt(cws.HWB,'FCFAD','freight') As FreightAmount_AI_OI, 
           kwereport.f_waybillamt(cws.HWB,'FCFAD','freightCurr') As FreightCurrency_AI_OI, 
           kwereport.f_waybillamt(cws.HWB,'FCFAD','other') As OtherChargeCNY_AI_OI, 
           kwereport2.f_chargecode_amt(cws.HWB,cws.BUSINESS_TYPE,cws.TRANSPORT_MODE) As charge_amt, 
           kwereport2.f_chargecode_cost(cws.HWB,cws.BUSINESS_TYPE,cws.TRANSPORT_MODE) As charge_cost 
    From  HWB_SUMMARY cws 
          Left Join HWB_CHARGE cwc On cws.HWB=cwc.HWB 
          Left Join HWB_DETAIL cwd On cws.HWB=cwd.HWB 
          Left Join DEL_DETAIL dd On cws.HWB=dd.HWB 
          Left Join DEL_SUMMARY ds On dd.DELIVERY_INSTRUCTION_NO=ds.DELIVERY_INSTRUCTION_NO 
    Where cws.COMPANY='510' and cws.TERMINAL='5101' 
    and cws.TRANSPORT_MODE='Air' and cws.BUSINESS_TYPE='Import' 
    and (cws.HWB_STATUS='O' Or cws.HWB_STATUS='OI' Or cws.HWB_STATUS='C' Or cws.HWB_STATUS='CAN' Or cws.HWB_STATUS='CNF' Or cws.HWB_STATUS='ICF' or cws.HWB_STATUS='IS' Or cws.HWB_STATUS='OIE') 
    and kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*')>=to_date('2006-2-1','yyyy-mm-dd') 
    and kwereport.f_ata(cws.HWB,cws.MWB,cws.TRANSPORT_MODE,'*')<to_date('2006-3-1','yyyy-mm-dd')
    and kwereport.f_portdest(cws.HWB,cws.BUSINESS_TYPE)='PVG'
      

  3.   

    Left Join DEL_SUMMARY ds On dd.DELIVERY_INSTRUCTION_NO=ds.DELIVERY_INSTRUCTION_NO 
    -------
    Left Join DEL_SUMMARY ds On cws.DELIVERY_INSTRUCTION_NO=ds.DELIVERY_INSTRUCTION_NO 
      

  4.   

    问题找到了，出在里面的function上，谢谢各位支持！