日期:2014-05-18 浏览次数:20550 次
select zz from c where zz in (select xx from a where xx>0 union all select yy from b where yy >0)
------解决方案--------------------
select zz from c where zz
in(select xx from aa where xx not in(select yy from bb)) --在a且不在b
or in(select yy from bb where yy not in(select xx from aa)) --在b且不在a