MS-SQL Server
这样的语句为什么能SELECT 但不能Delete纪录
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区delete FROM dbo.ttt
WHERE dbo.ttt.TaskID IN (
Select dbo.Fee_TaskTrace.TaskID From Fee_TaskTrace INNER JOIN Fee_CallLog ON
Fee_CallLog.CallID = Fee_TaskTrace.CallID
where Fee_CallLog.BeginTime > '2005-5-2 23:59:59' AND
Fee_CallLog.CallType = '1'
)
在查询分析器中一直在运行,不能给出结果
SELECT * FROM Fee_DetailBillTemp
WHERE dbo.ttt.TaskID IN (
Select dbo.Fee_TaskTrace.TaskID From Fee_TaskTrace INNER JOIN Fee_CallLog ON
Fee_CallLog.CallID = Fee_TaskTrace.CallID
where Fee_CallLog.BeginTime > '2005-5-2 23:59:59' AND
Fee_CallLog.CallType = '1'
)
但select 马上就能给出结果,ttt表中taskid有重复的,但表中有自增长ID,请大侠们帮忙!
WHERE dbo.ttt.TaskID IN (
Select dbo.Fee_TaskTrace.TaskID From Fee_TaskTrace INNER JOIN Fee_CallLog ON
Fee_CallLog.CallID = Fee_TaskTrace.CallID
where Fee_CallLog.BeginTime > '2005-5-2 23:59:59' AND
Fee_CallLog.CallType = '1'
)
在查询分析器中一直在运行,不能给出结果
SELECT * FROM Fee_DetailBillTemp
WHERE dbo.ttt.TaskID IN (
Select dbo.Fee_TaskTrace.TaskID From Fee_TaskTrace INNER JOIN Fee_CallLog ON
Fee_CallLog.CallID = Fee_TaskTrace.CallID
where Fee_CallLog.BeginTime > '2005-5-2 23:59:59' AND
Fee_CallLog.CallType = '1'
)
但select 马上就能给出结果,ttt表中taskid有重复的,但表中有自增长ID,请大侠们帮忙!
...全文
