select u.name, u.status from
(select h.name, h.status from have h union all select a.name, a.status from addon a) u
group by u.name,u.status having COUNT(*) < 2