Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Error #700 in FROM Clause |
Tue, Mar 6 2007 7:38 PM | Permanent Link |
Richard Harding | 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 |
Wed, Mar 7 2007 11:17 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |