join help

[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.

[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

[sde]

thanks djm.. i saw this last night but 2am was too late to give it a shot.

i got it working today and i get 3 rows for every one completely related record. for example

+-----+------------+------------+-------------+---------+-------+
| nid | body       | created    | title       | artist  | album |
+-----+------------+------------+-------------+---------+-------+
|  32 | test       | 1177359050 | NULL        | NULL      | NULL  |
|  32 | test       | 1177359050 | NULL        | NULL      | NULL  |
|  32 | test       | 1177359050 | mytitle      | myartist | myalbum  |

i just added 'title is not null' to the where clause and i get the set i'm looking for.

thanks.