2、INORORIGINISNULL) AND (a.DEST=DESTORDESTISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=CONSIGNOR_CUSTOMER_CODEORCONSIGNOR_CUSTOMER_CODEISNULL) AND (a.CONSIGNOR_NAMELIKE'%'+CONSIGNOR_NAME+'%'ORCONSIGNOR_NAMEISNULL) AND (
3、a.CONSIGNEE_NAMELIKE'%'+CONSIGNEE_NAME+'%'ORCONSIGNEE_NAMEISNULL) AND (a.CODIFY_ON, a.CREATED_ON, a.CONSIGNOR_CUSTOMER_CODE, a.CONSIGNOR_CODE, a.CONSIGNOR_NAME, a.CONSIGNEE_NAME, a.C
4、TB_CWBASa LEFTJOIN TB_CWBWEIGHTASb ON a.CWB_NO=b.CWB_NO AND b.AVAILABLE='Y' WHERE a.AVAILABLE='Y' AND (a.CWB_NO='31017768390'OR (('31010930775'ISNULL) AND
5、 (a.AWB_NO=NULLORNULLISNULL) AND (a.BWB_NO=NULLORNULLISNULL) AND (a.IE_TYPE=NULLORNULLISNULL) AND (a.CREATED_ON>=NULLORNULLISNULL) AND (a.CREATED_ON<= NULLORNULLISNULL) A123下一页>>>>这篇文章来自..,。ND (a.PAYMENT=NULLORNULLI
6、SNULL) AND (a.ORIGIN=NULLORNULLISNULL) AND (a.DEST=NULLORNULLISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=NULLORNULLISNULL) AND (a.CONSIGNOR_NAMELIKE'%'+NULL+'%'ORNULLISNULL) AND (a.CONSIGNEE_NAMELIKE'%'
7、+NULL+'%'ORNULLISNULL) AND (a.CODIFY_ON, a.CREATED_ON, a.CONSIGNOR_CUSTOMER_CODE, a.CONSIGNOR_CODE, a.CONSIGNOR_NAME, a.CONSIGNEE_NAME, a.C TB_CENT=PAYMENTORPAYMENTISNULL) AND (a.ORIGIN
8、=ORIGINORORIGINISNULL) AND (a.DEST=DESTORDESTISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=CONSIGNOR_CUSTOMER_CODEORCONSIGNOR_CUSTOMER_CODEISNULL) AND (a.CONSIGNOR_NAMELIKE''%''+CONSIGNOR_NAME+''%''OR