Hi,
I'm trying to outer join the same table twice ir more like that:

"SELECT author,
co_author_1,
s.bio_url AS au_bio,
s1.bio_url AS co1_bio
FROM articles AS a
LEFT JOIN staff s ON (a.author = s.person_name)
LEFT JOIN staff s1 ON (a.author = s1.person_name)
WHERE article_section='commentary' ORDER BY article_date DESC"

and I get the following error :

Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression '(a.author = s.person_name) LEFT JOIN staff s1 ON (a.author = s1.person_name)'.

what os the correct way to do this
thanks

you need to parenthesize two tables at a time whenever there are more than two tables in the query:

thank u so much!