How to find values from one table missing in another?
select author from article where author IS NOT NULL and author &lt;&gt; ''
except 
select name   from author


since any comparison the null is false I think below works 

select author from article where author &lt;&gt; ''
except 
select name   from author