select from two tables into a single column

delete from user where id not in (select a.id from person a UNION select b.id from merchant b)