So apparently I should have asked earlier
Found the solution
Although title
was in this.Professors
, title
was Professor Snape
while this.Professors
was [[Professor Snape]]
Solution
TABLE WITHOUT ID
link(file.link, title) AS "Name",
email AS "E-Mail",
office_hours AS "Hours"
FROM #People
WHERE
any(contains(file.link, this.Professors))