|
发表于 2017-5-31 15:54:31
|
显示全部楼层
SELECT CBMP_TechValidate.fID AS CBMP_TechValidate, CBMP_TechValidate.FBIZSTATE AS fBizState, CBMP_TechValidate.FBIZSTATENAME AS fBizStateName, CBMP_TechValidate.FCREATEDEPTID AS fCreateDeptID, CBMP_TechValidate.FCREATEDEPTNAME AS fCreateDeptName, CBMP_TechValidate.FCREATEDEPTPATH AS fCreateDeptPath, CBMP_TechValidate.FCREATEDEPTPATHNAME AS fCreateDeptPathName, CBMP_TechValidate.FCREATEOGNID AS fCreateOgnID, CBMP_TechValidate.FCREATEORGNAME AS fCreateOrgName, CBMP_TechValidate.FCREATEORGPATH AS fCreateOrgPath, CBMP_TechValidate.FCREATEORGPATHNAME AS fCreateOrgPathName, CBMP_TechValidate.FCREATEPERID AS fCreatePerID, CBMP_TechValidate.FCREATEPERNAME AS fCreatePerName, CBMP_TechValidate.FCREATEPERPATH AS fCreatePerPath, CBMP_TechValidate.FCREATEPERPATHNAME AS fCreatePerPathName, CBMP_TechValidate.FCREATETIME AS fCreateTime, CBMP_TechValidate.FDATE AS fDate, CBMP_TechValidate.FDATEB AS fDateB, CBMP_TechValidate.FMASTERID AS fMasterID, CBMP_TechValidate.FNO AS fNO, CBMP_TechValidate.FPROJECTID AS fProjectID, CBMP_TechValidate.FPROJECTNAME AS fProjectName, CBMP_TechValidate.FVALIDATECONCLUSION AS fValidateConclusion, CBMP_TechValidate.FVALIDATEHEAD AS fValidateHead, CBMP_TechValidate.FVALIDATEPER AS fValidatePer, CBMP_TechValidate.FVALIDATERECORD AS fValidateRecord, CBMP_TechValidate.FVALIDATIONMETHOD AS fValidationMethod, CBMP_TechValidate.VERSION AS version FROM CBMP_TECHVALIDATE CBMP_TechValidate
这个是要显示的表的sql?没有主从设置的where条件啊 |
|