View Incident Report

Serious

Reported By: Richard Harding
Reported On: 3/6/2007
For: Version 1.01 Build 1

# 2262 Adding a RIGHT OUTER JOIN to a Table Involved in a CROSS JOIN Causes Error Message

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).

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

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

Workaround:

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

Resolution

Fixed Problem on 3/10/2007 in version 1.02 build 1

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap