数据集合一
select goodsid from bsgoods
有全部的id
数据集合二
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType='进货') a
union
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType like '%销售%') b中的goodsid 有部分的id我想查询数据集合一中不包含数据集合二的goodsid,要如何查询?
select goodsid from bsgoods
有全部的id
数据集合二
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType='进货') a
union
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType like '%销售%') b中的goodsid 有部分的id我想查询数据集合一中不包含数据集合二的goodsid,要如何查询?
(Select Distinct GoodsID from InvAccStock where SheetType='进货') a
union
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType like '%销售%') b
)
select goodsid from bsgoods
有全部的id
数据集合二
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType='进货') a
union
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType like '%销售%') b --EXCEPT
select goodsid from bsgoods
EXCEPT
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType='进货') a
union
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType like '%销售%') b
except
集合二
except
集合二select goodsid from bsgoods
EXCEPT
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType='进货') a
union
Select GoodsID From
(Select Distinct GoodsID from InvAccStock where SheetType like '%销售%') b