ho risolto a caso ma ho risolto così:

SELECT t_staff_notes.id AS 'ID', t_staff_notes.date AS 'DATA CREAZIONE', t_staff_notes.last_date AS 'ULTIMA MODIFICA', t_staff_notes.closed_date AS 'CHIUSA IL', t_staff_notes.status AS 'STATO', t_staff_notes.subject AS 'OGGETTO', t_staff_notes.note AS 'NOTA', t_company.name AS 'CLIENTE' FROM t_company join t_contracts join t_staff_notes WHERE t_company.id_company = t_contracts.id_company AND t_staff_notes.id_contracts = t_contracts.id_contracts ORDER BY id DESC


t_company join t_contracts join t_staff_notes è stata la mia salvezza