我必须找到我们的目录中没有列出的sku(标识符)。Querys很简单
SELECT sku
FROM stock
WHERE sku NOT IN (SELECT sku FROM catalog)
但在桌子销售中可能也会缺少sku的
SELECT DISTINCT sku
FROM sale
WHERE sku NOT IN (SELECT sku FROM catalog)
我想从mysql获得一个结果,将所有缺少的skus。用Union连接这两个查询在这里是行不通的。谢谢&致以最良好的问候
发布于 2019-06-20 03:41:27
您可以尝试使用UNION
SELECT sku
FROM stock
WHERE sku NOT IN (SELECT sku FROM catalog)
union
SELECT sku
FROM sale
WHERE sku NOT IN (SELECT sku FROM catalog)
为了从这两个查询中获得distink
或
select sku
from (
SELECT sku FROM stock
union
SELECT sku FROM sale
) t
where sku NOT IN (SELECT sku FROM catalog)
无论如何,第一个应该更有性能
https://stackoverflow.com/questions/56674757
复制相似问题