|
|
发表于 2016-2-23 17:10:05
|
显示全部楼层
- SELECT BC_MT_Project.VERSION AS version, BC_MT_Project.FGCMC AS fGCMC, BC_MT_Project.FJSDW AS fJSDW, BC_MT_Project.FSZDY AS fSZDY, BC_MT_Project.FDYFW AS fDYFW, BC_MT_Project.FYYDW AS fYYDW, BC_MT_Project.FGCJC AS fGCJC, BC_MT_Project.FGCLXBM AS fGCLXBM, BC_MT_Project.FTBHNPXMJL AS fTBHNPXMJL, BC_MT_Project.FGCDD AS fGCDD, BC_MT_Project.FJGLX AS fJGLX, BC_MT_Project.FCS AS fCS, BC_MT_Project.FZBJ AS fZBJ, BC_MT_Project.FJZMJ AS fJZMJ, BC_MT_Project.FQZDS AS fQZDS, BC_MT_Project.FDX AS fDX, BC_MT_Project.FSFLY AS fSFLY, BC_MT_Project.FXMGK AS fXMGK, BC_MT_Project.FLXBZ AS fLXBZ, BC_MT_Project.FCJDW AS fCJDW, BC_MT_Project.FSGXMB AS fSGXMB, BC_MT_Project.FJLDW AS fJLDW, BC_MT_Project.FSJDW AS fSJDW, BC_MT_Project.FZJDW AS fZJDW, BC_MT_Project.FZBRQ AS fZBRQ, BC_MT_Project.FZBFS AS fZBFS, BC_MT_Project.FXMJL AS fXMJL, BC_MT_Project.FKGXKZH AS fKGXKZH, BC_MT_Project.FGHXKZH AS fGHXKZH, BC_MT_Project.FGCZJ AS fGCZJ, BC_MT_Project.FHTKGRQ AS fHTKGRQ, BC_MT_Project.FHTJGRQ AS fHTJGRQ, BC_MT_Project.FZRLGC AS fZRLGC, BC_MT_Project.FCBFW AS fCBFW, BC_MT_Project.FGMFL AS fGMFL, BC_MT_Project.FCBMS AS fCBMS, BC_MT_Project.FSZDW AS fSZDW, BC_MT_Project.FDWID AS fDWID, BC_MT_Project.FDWFID AS fDWFID, BC_MT_Project.FFJ1 AS fFJ1, BC_MT_Project.FSFJTZDXM AS fSFJTZDXM, BC_MT_Project.FSBZT AS fSBZT, BC_MT_Project.FZLMB AS fZLMB, BC_MT_Project.FCYMB AS fCYMB, BC_MT_Project.FJTBH AS fJTBH, BC_MT_Project.FTBFID AS fTBFID, BC_MT_Project.FTBR AS fTBR, BC_MT_Project.FTBRID AS fTBRID, BC_MT_Project.FXMZXFL AS fXMZXFL, BC_MT_Project.FGMFLL AS fGMFLL, BC_MT_Project.FGMXZ AS fGMXZ, BC_MT_Project.FJGLXX AS fJGLXX, BC_MT_Project.FYTFL AS fYTFL, BC_MT_Project.FGCLX AS fGCLX, BC_MT_Project.FSZSF AS fSZSF, BC_MT_Project.FSZDWBM AS fSZDWBM, BC_MT_Project.FBZRQ AS fBZRQ, BC_MT_Project.FSZDYBM AS fSZDYBM, BC_MT_Project.FBGRQ AS fBGRQ, BC_MT_Project.FBGCS AS fBGCS, BC_MT_Project.FSZSFBM AS fSZSFBM, BC_MT_Project.FSZCSBM AS fSZCSBM, BC_MT_Project.FXMZXFLBM AS fXMZXFLBM, BC_MT_Project.FGMFLBM AS fGMFLBM, BC_MT_Project.FXMXZBM AS fXMXZBM, BC_MT_Project.FCBMSBM AS fCBMSBM, BC_MT_Project.FJGLXBM AS fJGLXBM, BC_MT_Project.FYTFLBM AS fYTFLBM, BC_MT_Project.FGCFLBM AS fGCFLBM, BC_MT_Project.FSFJTMYZB AS fSFJTMYZB, BC_MT_Project.FBZ2 AS fBZ2, BC_MT_Project.FSGZT AS fSGZT, BC_MT_Project.FZZJD AS fZZJD, BC_MT_Project.FWCXMBJ AS fWCXMBJ, BC_MT_Project.FXMJLBMMC AS FXMJLBMMC, BC_MT_Project.FSFWB AS fSFWB, BC_MT_Project.FXMSZBM AS fXMSZBM, BC_MT_Project.FSJKGRQ AS fSJKGRQ, BC_MT_Project.FFJ AS fFJ, BC_MT_Project.FSHDW AS fSHDW, BC_MT_Project.FSHR AS fSHR, BC_MT_Project.FSHSJ AS fSHSJ, BC_MT_Project.FQZDSC AS fQZDSC, BC_MT_Project.FQZDXC AS fQZDXC, BC_MT_Project.FYG AS fYG, BC_MT_Project.FXMXGTFJ AS fXMXGTFJ, BC_MT_Project.FXM AS fXM, BC_MT_Project.FZDWCHTE AS fZDWCHTE, BC_MT_Project.FLXDH AS fLXDH, BC_MT_Project.FDATATYPE AS fDataType, BC_MT_Project.FSGBW AS fSGBW, BC_MT_Project.FSFCBGC AS fSFCBGC, BC_MT_Project.FSWJL AS fSWJL, BC_MT_Project.FSWJLDH AS fSWJLDH, BC_MT_Project.FJFSFJTNBDW AS fJFSFJTNBDW, BC_MT_Project.FSZQYGS AS fSZQYGS, BC_MT_Project.FHTXS AS fHTXS, BC_MT_Project.FMANAGEEXPENSERATE AS fManageExpenseRate, BC_MT_Project.FMANAGEEXPENSE AS fManageExpense, BC_MT_Project.FSFQDZRS AS fSFQDZRS, BC_MT_Project.FECONCREATOR AS fECONCreator, BC_MT_Project.FECONCREATEDEPT AS fECONCreateDept, BC_MT_Project.FECONCREATEDATE AS fECONCreateDate, BC_MT_Project.FECONCREATORFID AS fECONCreatorFID, BC_MT_Project.FSGZT2 AS fSGZT2, BC_MT_Project.FSJJGRQ AS fSJJGRQ, BC_MT_Project.FPROTOCOL AS fProtocol, BC_MT_Project.FPROTOCOLID AS fProtocolID, BC_MT_Project.FPROTOCOLCODE AS fProtocolCode, BC_MT_Project.FAREA AS fArea, BC_MT_Project.FAREACODE AS fAreaCode, BC_MT_Project.FLCJD AS fLCJD, BC_MT_Project.FLCSX AS fLCSX, BC_MT_Project.FGCGM AS fGCGM, BC_MT_Project.FGCGMDW AS fGCGMDW, BC_MT_Project.FTBJSFZR AS fTBJSFZR, BC_MT_Project.FTBZLY AS fTBZLY, BC_MT_Project.FTBAQY AS fTBAQY, BC_MT_Project.FZLBZ AS fZLBZ, BC_MT_Project.FSFQDZB AS fSFQDZB, BC_MT_Project.FZBTZSQDRQ AS fZBTZSQDRQ, BC_MT_Project.FFZJGMC AS fFZJGMC, BC_MT_Project.FFZJGFCODE AS fFZJGFCODE, BC_MT_Project.FFZJGFID AS fFZJGFID, BC_MT_Project.FSFQDSGHT AS fSFQDSGHT, BC_MT_Project.FCBNR AS fCBNR, BC_MT_Project.FSFYKGZ AS fSFYKGZ, BC_MT_Project.FXMSCJL AS fXMSCJL, BC_MT_Project.FXMZG AS fXMZG, BC_MT_Project.FWHDW AS fWHDW, BC_MT_Project.FWHR AS fWHR, BC_MT_Project.FWHRQ AS fWHRQ, BC_MT_Project.FECONSTATE AS fECONState, BC_MT_Project.FECONSTATEID AS fECONStateID, BC_MT_Project.fID AS BC_MT_Project FROM BC_MT_PROJECT BC_MT_Project WHERE (fDataType = '原始') AND ( ( (fSBZT = '未上报') AND (fDWID = 'A120100000000') ) OR ( (fTBRID = '941B0600D0384337A815CDD6BC6D9467') AND (fLCSX IS NOT NULL) ) ) ORDER BY fSBZT ASC, fLCSX ASC, fBZRQ DESC
这个在数据库中执行没问题？ |
|
IP卡
狗仔卡
显身卡
楼主
