I can do multiple outer joins in sql server without any parenthesis fine and it works perfectly. But when trying to do it with an access database I get an error.. There is a way to do its just a matter of syntax. Grouping with parenthesis. I cannot get it right. I can one but thats it.<BR><BR>SELECT t11.id,t21.id FROM (users t11 LEFT OUTER JOIN users t21 ON(t21.enrollerid=t11.Id))<BR><BR>If I try..<BR><BR>SELECT t11.id,t21.id,t22.id FROM ((users t11 LEFT OUTER JOIN users t21 ON(t21.enrollerid=t11.Id)) LEFT OUTER JOIN (t22.enrollerid=t11.id AND t22.id &#060;&#062; t21.id))<BR><BR>I get an error <BR>Microsoft JET Database Engine error &#039 80040e14&#039 <BR><BR>Join expression not supported. <BR><BR>/test.asp, line 36 <BR><BR>What am I doing wrong?