SELECt O.Id
FROM Orders O
JOIN Order_details OD ON O.Id=OD.Order_Id
WHERe O.Status=’OK’
GROUP BY O.Id
HAVINg count(DISTINCT OD.Id)>1
AND SUM(CASE WHEN OD.Status NOT IN (‘S1’,’S2’)
THEN 1
ELSE 0
END) = 0
SELECt O.Id
FROM Orders O
JOIN Order_details OD ON O.Id=OD.Order_Id
WHERe O.Status=’OK’
GROUP BY O.Id
HAVINg count(DISTINCT OD.Id)>1
AND SUM(CASE WHEN OD.Status NOT IN (‘S1’,’S2’)
THEN 1
ELSE 0
END) = 0
上一篇 是否可以在不指定数据库的情况下连接到SQL Server？
下一篇 The Transaction Ended In The Trigger The Batch Has Been Aborted
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
