sql三表连接问题

显示全部楼层 · 2012-10-31 18:52:44

你ccc表的xid和ddd表的xid是什么关系？如果是一样的：select a.id from bbb aleft join ccc b on a.id=b.uidleft join ddd c on a.id=c.uidwhere b.xid=30如果不一样那后边再加上 and c.xid=30...

千问 · 2012-10-31 18:52:44

按如下语句试试，oracle和sqlserver都通用。SELECT Bbb.IdFROM Bbb WHERE EXISTS (SELECT 1
FROM Ccc,
Ddd
WHERE Ccc.Uid = Ddd.Uid
AND Ccc.Xid ...

千问 · 2012-10-31 18:52:44

select a.id from bbb a join ccc b on a.id=b.uid join ddd c on c.id=b.uid where b.xid=30 and c.xid=30...

千问 · 2012-10-31 18:52:44

同意解0人...