UC知道SQL命令错误“当没有用 EXISTS 引入子查询时,在选择列表中只能指定一个表达式。”
来源：百度知道 编辑：UC知道 时间：2024/06/03 20:46:10
DELETE FROM T_SubsidyNotPutOut
WHERE ((CustomerID + [Month] + Subsidy) IN
(SELECT a.CustomerID, a.[Month], a.Subsidy
FROM T_SubsidyNotPutOut a, T_SubsidyPutOut b
WHERE a.CustomerID = b.CustomerID AND a.[Month] = b.[Month] AND
a.Subsidy = b.Subsidy))
运行时出现错误 帮忙看一下是哪里出问题了 谢谢
WHERE ((CustomerID + [Month] + Subsidy) IN
(SELECT a.CustomerID, a.[Month], a.Subsidy
FROM T_SubsidyNotPutOut a, T_SubsidyPutOut b
WHERE a.CustomerID = b.CustomerID AND a.[Month] = b.[Month] AND
a.Subsidy = b.Subsidy))
运行时出现错误 帮忙看一下是哪里出问题了 谢谢
DELETE FROM T_SubsidyNotPutOut
WHERE exists
(SELECT a.CustomerID, a.[Month], a.Subsidy
FROM T_SubsidyNotPutOut a, T_SubsidyPutOut b
WHERE a.CustomerID = b.CustomerID AND a.[Month] = b.[Month] AND
a.Subsidy = b.Subsidy)
in 是用于某一个字段的集合，你是同时三个字段，所以要用exists