Join 3 Tables.. help..

[joey3002]

Any help would be well appreciated. For some reasons, joining is not something that I can do easily even after reading. So this is why I need help.

Here is what I have and it works:
SELECT fid, subject, date, subj_ng.ng_id FROM subj_title LEFT JOIN subj_data USING (fid) WHERE subj_title.fid IN('.implode($fids,",").') LIMIT 1000';

now, I also want to get 1 other item, its in n_name table, but to get it, I need to use the fid, to get the n_name_id from n_group and then use the n_name_id in n_name to get the name from n_name table.

wow.. hope that makes sense to someone..
thanks

[bogu]

Use like this:

SELECT * FROM table
LEFT JOIN table1 USING(field)
LEFT JOIN table2 ON tabel2.field1 = table.field2
WHERE conds ...

This is how u join with 3 tables if both table1 and table2 link with table..