I wrote a query, but I used a subquery. I am not satified. But I don't know how to avoid a subquery like that. I want to exclude the names in the third table blacklist. Appreciated!!!
SELECT v1.name ... from view1 as v1
inner join table2 as t2 on v1.name = t2.name
where v1.name not in (select v1.name from view1 inner join blacklist bl on v1.name = bl.name)