select storageid,materialid from m_stockaccount where erasign = '0'
minus
select storageid,materialid from m_fourplace where erasign = '0'
minus
select storageid,materialid from m_fourplace where erasign = '0'
WHERE NOT EXISTS (SELECT * FROM B WHERE B.ID = A.ID)
select a.name,b.age from a,b where a.name*=b.name having not exists(b.age)