una cosa tipo questa, tutta da testare

codice:
SELECT c.name 
FROM t_staff_notes AS a INNER JOIN t_contracts as b ON a.id_contracts = b.id_contracts 
INNER JOIN t_company as c ON b.id_company = c.id_company