I have a bunch of self-joined tables with the LEFT OUTER JOIN FEATURE. In sql server this kind of query is ok but when I try it do it on the access db I get an error.. Its possible to do just one outer-join but when i try two or more i get the error. heres the query. Its kindof confusing.. basically I just need the syntax of doing multiple outer-joins.... <BR><BR>SELECT t11.id,t21.id,t22.id,t31.id,t32.id,t33.id,t34.id FROM users t11 LEFT OUTER JOIN users t21 ON(t21.enrollerid=t11.Id) LEFT OUTER JOIN users t22 ON(t22.enrollerid=t11.Id AND t22.id <> t21.id) LEFT OUTER JOIN users t31 ON(t31.enrollerid=t21.Id) LEFT OUTER JOIN users t32 ON(t32.enrollerid=t21.Id AND t32.id <> t31.id) LEFT OUTER JOIN users t33 ON(t33.enrollerid=t22.Id) LEFT OUTER JOIN users t34 ON(t34.enrollerid=t22.Id AND t34.id <> t33.id) <BR><BR>Is there another way to do outer joins? Perhaps an operator like *= or += or something like that? Or what is the correct way to represent this query?