select t.物品 from (select * from a,b where b.柜子=a.柜子(+) t group by 仓库,物品 having count(1)>1;
select a.sid,a.cid,b.item from a,b where a.cid = b.cid group by a.sid,a.cid,b.item having max(a.sid||a.cid) <> min(a.sid||a.cid);
select a.sid,b.item,count(1) from a,b where a.cid = b.cid group by a.sid,b.item having count(1) > 1
谢谢两位, bzszp(SongZip)的语句好像可以, 但我想列出一个比较详细的错误清单:仓库 柜子 物品 -------------------- AA 01 555 AA 02 555 BB 11 666 BB 12 666 ........谢谢指教
onejune4450的好像查不到数据。
sid 库,cid 柜,item 物 select c.sid,b.cid,c.item from ( (select a.sid,b.item from a,b where a.cid = b.cid group by a.sid,b.item having count(1) > 1 )c,a,b where a.cid = b.cid and c.cid = b.cid and c.item = b.item
sid 库,cid 柜,item 物 select c.sid,b.cid,c.item from ( (select a.sid,b.item from a,b where a.cid = b.cid group by a.sid,b.item having count(1) > 1 )c,a,b where a.cid = b.cid and c.cid = b.cid and c.item = b.item通不过啊,大哥
试试下面这个 select c.仓库,c.柜子,c.物品 from (select a.仓库,a.柜子,b.物品 from a,b where a.柜子(+) = b.柜子) c, (select a.仓库,a.柜子,b.物品 from a,b where a.柜子(+) = b.柜子) d where c.仓库 = d.仓库 and c.柜子 <> d.柜子;
sid 库,cid 柜,item 物 多了个'(' select c.sid,b.cid,c.item from (select a.sid,b.item from a,b where a.cid = b.cid group by a.sid,b.item having count(1) > 1 )c,a,b where a.cid = b.cid and c.cid = b.cid and c.item = b.item
group by 仓库,物品 having count(1)>1;
from a,b
where a.cid = b.cid
group by a.sid,a.cid,b.item
having max(a.sid||a.cid) <> min(a.sid||a.cid);
from a,b
where a.cid = b.cid
group by a.sid,b.item
having count(1) > 1
bzszp(SongZip)的语句好像可以,
但我想列出一个比较详细的错误清单:仓库 柜子 物品
--------------------
AA 01 555
AA 02 555
BB 11 666
BB 12 666
........谢谢指教
select c.sid,b.cid,c.item from (
(select a.sid,b.item
from a,b
where a.cid = b.cid
group by a.sid,b.item
having count(1) > 1 )c,a,b
where a.cid = b.cid
and c.cid = b.cid
and c.item = b.item
select c.sid,b.cid,c.item from (
(select a.sid,b.item
from a,b
where a.cid = b.cid
group by a.sid,b.item
having count(1) > 1 )c,a,b
where a.cid = b.cid
and c.cid = b.cid
and c.item = b.item通不过啊,大哥
select c.仓库,c.柜子,c.物品
from
(select a.仓库,a.柜子,b.物品
from a,b
where a.柜子(+) = b.柜子) c,
(select a.仓库,a.柜子,b.物品
from a,b
where a.柜子(+) = b.柜子) d
where c.仓库 = d.仓库 and c.柜子 <> d.柜子;
多了个'('
select c.sid,b.cid,c.item from
(select a.sid,b.item
from a,b
where a.cid = b.cid
group by a.sid,b.item
having count(1) > 1 )c,a,b
where a.cid = b.cid
and c.cid = b.cid
and c.item = b.item