Advanced SELECT Syntax Help Needed!

[Monique]

Hi!

 

I would love some help with my syntax (or another strategy). I keep bombing.
I've simplified it. Here is the deal: 

Three files: 

Main: id, name 
Links1: id, linkname1 (a record may or may not exist for each record in
Main) 
Links2: id, linkname2 (a record may or may not exist for each record in
Main) 

I need a list of every record in main plus linkname1 and linkname2. I am
trying to use a subquery. 

SELECT name, linkname2, links1.id, links1.linkname1 
FROM 
(SELECT main.id, main.name, links2.linkname2 from main 
LEFT OUTER JOIN links2 using (id)) AS subfile 
LEFT OUTER JOIN links1 using (id) 

I keep getting syntax errors. I would really appreciate any input. Thanks a
bunch -- 

Monique.