[DJMaze]

select n.text, a.title, f.f_id
  from n, f
  left join a on a.f_id=f.f_id
  where n.n_id=f.n_id

Some databases need the relation in the select.
The "inner join" of n+f makes sure that both n and f exist