Credits (ID int, Name varchar) 
Paints (ID int, Name varchar) 
Mans (ID int, CreditID int, PaintID int)

select
  C.Name
from Mans M
  inner join Credits C on C.ID = M.CreditID
group by
  M.CreditID, C.Name
having(count(distinct M.PaintID)) = (select count(*) from Paints)