[sde]

table: n
n_id
text

table: f
f_id
n_id

table: a
f_id
title


i need to join these 3 tables but i'm having trouble. i get null data in the field's i'm requesting from table a.

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

for suggestions, assume there is one record in each table with table f associating tables n and a.

any help would be appreciated.