|

楼主 |
发表于 2018-5-11 15:32:24
|
显示全部楼层
本帖最后由 dh_n 于 2018-5-11 15:34 编辑
- --> sql:SELECT DISTINCT ERP_Customer.FCUSTOMERNAME AS CustomerName, ERP_WH_OutInWarehouseRecord.FDOCUMENTNUMBER AS DocumentNumber, ERP_DG_TotalBoxList.fID AS ERP_DG_TotalBoxList, ERP_WH_Warehouse.FFWAREHOUSENAME AS WareHouseName, SA_OPPerson_1.SNAME AS bName, SA_OPPerson.SNAME AS cName, ERP_DG_TotalBoxList.FATTACHMENT AS fAttachment, ERP_DG_TotalBoxList.FATTACHMENT1 AS fAttachment1, ERP_DG_TotalBoxList.FBIZSTATE AS fBizState, ERP_DG_TotalBoxList.FBIZSTATENAME AS fBizStateName, ERP_DG_TotalBoxList.FCARNUMBER AS fCarNumber, ERP_DG_TotalBoxList.FCHECKDATE AS fCheckDate, ERP_DG_TotalBoxList.FCHECKER AS fChecker, ERP_DG_TotalBoxList.FCOURIERNUMBER AS fCourierNumber, ERP_DG_TotalBoxList.FCREATEDATETIME AS fCreateDateTime, ERP_DG_TotalBoxList.FCREATEPERSONID AS fCreatePersonID, ERP_DG_TotalBoxList.FCREATEPERSONNAME AS fCreatePersonName, ERP_DG_TotalBoxList.FCURRENTACTIVITIES AS fCurrentActivities, ERP_DG_TotalBoxList.FCURRENTEXECUTORS AS fCurrentExecutors, ERP_DG_TotalBoxList.FCUSTOMERCODE AS fCustomerCode, ERP_DG_TotalBoxList.FCUSTOMERID AS fCustomerID, ERP_DG_TotalBoxList.FCUSTOMERNAME AS fCustomerName, ERP_DG_TotalBoxList.FDELIVERGOODSNUMBER AS fDeliverGoodsNumber, ERP_DG_TotalBoxList.FDELIVERYDATE AS fDeliveryDate, ERP_DG_TotalBoxList.FEXPLAIN AS fExplain, ERP_DG_TotalBoxList.FGROSSWEIGHTCTN AS fGROSSWEIGHTCTN, ERP_DG_TotalBoxList.FINBOUNDDATETIME AS fInBoundDateTime, ERP_DG_TotalBoxList.FINVOICENO AS fInvoiceNo, ERP_DG_TotalBoxList.FISUSED AS fIsUsed, ERP_DG_TotalBoxList.FLNSPECTIONLIST AS fLnspectionList, ERP_DG_TotalBoxList.FMAILBOX AS fMailBox, ERP_DG_TotalBoxList.FMANAGERTELEPHONENUMBER AS fManagerTelephoneNumber, ERP_DG_TotalBoxList.FMERGEORDERNO AS fMergeOrderNO, ERP_DG_TotalBoxList.FNETWEIGHTCTN AS fNETWEIGHTCTN, ERP_DG_TotalBoxList.FNUMBER AS fNumber, ERP_DG_TotalBoxList.FORGANNAME AS fOrganName, ERP_DG_TotalBoxList.FPACKINGLIST AS fPackingList, ERP_DG_TotalBoxList.FPHONE AS fPhone, ERP_DG_TotalBoxList.FREMARK AS fRemark, ERP_DG_TotalBoxList.FSAFEKEEPINGPERSONID AS fSafeKeepingPersonID, ERP_DG_TotalBoxList.FSHIPTO AS fShipTo, ERP_DG_TotalBoxList.FSHIPVIA AS fShipVia, ERP_DG_TotalBoxList.FSIGNATOREDATETIME AS fSignatoreDateTime, ERP_DG_TotalBoxList.FSIGNATORYID AS fSignatoryID, ERP_DG_TotalBoxList.FSOLDTO AS fSoldTo, ERP_DG_TotalBoxList.FSTATUS AS fStatus, ERP_DG_TotalBoxList.FSUMNUM AS fSumNum, ERP_DG_TotalBoxList.FTOTALPRICE AS fTotalPrice, ERP_DG_TotalBoxList.FWAREHOUSEID AS fWareHouseID, ERP_DG_TotalBoxList.FWAREHOUSEMANAGER AS fWareHouseManager, ERP_DG_TotalBoxList.FOUTBOUNDID AS foutBoundID, SA_OPPerson_2.SNAME AS jName, ERP_DG_TotalBoxList.VERSION AS version FROM ERP_DG_TOTALBOXLIST ERP_DG_TotalBoxList LEFT JOIN ERP_WH_OutInWarehouseRecord ERP_WH_OutInWarehouseRecord ON ERP_DG_TotalBoxList.FOUTBOUNDID = ERP_WH_OutInWarehouseRecord.fID LEFT JOIN SA_OPPerson SA_OPPerson ON ERP_DG_TotalBoxList.FCREATEPERSONID = SA_OPPerson.SID LEFT JOIN SA_OPPerson SA_OPPerson_1 ON ERP_WH_OutInWarehouseRecord.FSAFEKEEPINGPERSONID = SA_OPPerson_1.SID LEFT JOIN SA_OPPerson SA_OPPerson_2 ON ERP_DG_TotalBoxList.FCHECKER = SA_OPPerson_2.SID LEFT JOIN SA_Task SA_Task ON ERP_DG_TotalBoxList.fID = SA_Task.SDATA1 LEFT JOIN ERP_Customer ERP_Customer ON ERP_DG_TotalBoxList.FCUSTOMERCODE = ERP_Customer.FCUSTOMERCODE LEFT JOIN ERP_WH_Warehouse ERP_WH_Warehouse ON ERP_DG_TotalBoxList.FWAREHOUSEID = ERP_WH_Warehouse.fID WHERE (ERP_DG_TotalBoxList.FORGANNAME = ?) AND (? = ?) ORDER BY fPackingList ASC
- --> binds:[测试, 1, 0]
复制代码 WHERE (ERP_DG_TotalBoxList.FORGANNAME = ?) AND (? = ?) 我没有写 AND (? = ?),为什么会出现这个? |
|