请问为什么我如下delete语句说sql语句未正确结束呢，谢谢

显示全部楼层 · 2010-11-8 21:28:14

delete fromCHANNEL_MANAGER_ORG , CHANNEL_BASE_INFO
where CHANNEL_MANAGER_ORG.EMPLOYEE_ID = CHANNEL_BASE_INFO.EMPLOYEE_ID
and CHANNEL_BASE_INFO.IS_SYS_OP = 1
and CHANNEL_BASE_INFO.REC_STATUS = 1
and CHANNEL_BASE_INFO.COUNTY_CODE = 5775
and CHANNEL_BASE_INFO.SYS_OP_ID = 10132726

千问 · 2010-11-8 21:28:14

delete from delete from CHANNEL_MANAGER_ORG where CHANNEL_MANAGER_ORG.EMPLOYEE_ID in (select CHANNEL_BASE_INFO.EMPLOYEE_ID where CHANNEL_BASE_INFO.IS_SYS_OP = 1 and CHANNEL_BASE_INFO.REC_STATUS = 1and CHANNEL_BASE_INFO.COUNTY_CODE = 5775and CHANNEL_BASE_INFO.SYS_OP_ID = 10132726) 我想你大概是想这样做吧。删除表CHANNEL_MANAGER_ORG中EM

千问 · 2010-11-8 21:28:14

delete fromCHANNEL_MANAGER_ORG , CHANNEL_BASE_INFO很多SQL应该不支持这样多表删除的，

千问 · 2010-11-8 21:28:14

这些数'5775','10132726'应该是以文本来处理的，应加上单引号。