Using If and Vlookup in Postgresql
This should be easy with a NOT EXISTS subquery. Assuming the tables are as you show them:

selact a.*
from a
where "Current Stock" = 0
  and not exists
      ( select * 
        from b 
        where b.id = a.id
          and "Current Stock" &gt; 0
      ) ;