select E from m_consume t1,(select A from m_product union all select B from m_product union all select C from m_product union all select D from m_product) t2 where t1.e = t2.a(+) and t2.a is null
select E from m_consume where m_consume a,m_product b where a.e = b.a(+) and b.a is null and a.e = b.b(+) and b.b is null and a.e = b.c(+) and b.c is null and a.e = b.d(+) and b.d is null; 不知道效果怎样!
where t1.e = t2.a(+) and t2.a is null
where a.e = b.a(+) and b.a is null and a.e = b.b(+) and b.b is null
and a.e = b.c(+) and b.c is null and a.e = b.d(+) and b.d is null;
不知道效果怎样!