The following SQL Statement gives an error #700 at line 4 and column 7 (Invalid expression
"ClientPractitioner" found, this table is the target of multiple join conditions)

SELECT *
  FROM
     Configuration,
     ClientPractitioner
        RIGHT OUTER JOIN Client
           ON ClientPractitioner.ClientID = Client.ID
        LEFT OUTER JOIN Client AS Practitioner
           ON ClientPractitioner.PractitionerID = Practitioner.ID

If the Configuration table is moved to the end of the statement then it works.

SELECT *
  FROM
     ClientPractitioner
        RIGHT OUTER JOIN Client
           ON ClientPractitioner.ClientID = Client.ID
        LEFT OUTER JOIN Client AS Practitioner
           ON ClientPractitioner.PractitionerID = Practitioner.ID,
     Configuration

Richard,

<< The following SQL Statement gives an error #700 at line 4 and column 7
(Invalid expression "ClientPractitioner" found, this table is the target of
multiple join conditions) >>

Ok, got it.   A fix will be in build 2.

--
Tim Young
Elevate Software
www.elevatesoft.com