delete from a where a.col1 in (select distinct col1 from b)