34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM A AS T WHERE OID IN (
SELECT Oid FROM A WHERE NOT EXISTS(SELECT 1 FROM B WHERE UseOid=A.Oid) GROUP BY Oid HAVING COUNT(*)=1)
-- 大概这个样子
select * from a
union all
select from b where not exists(select * from a where a.id = b.id and a.no= b.no)