View Incident Report

Serious

Reported By: Ole Willy Tuv
Reported On: 12/11/2002
For: Version 3.20 Build 1

# 1290 Using an IN Sub-Select with Joins in an SQL Statement Causes a Join Parentheses Mismatch Error

I'm getting an exception with the following message:

"DBISAM Engine Error # 11949 SQL error - Mismatched join parentheses"

when executing the following query:

SELECT ID, SField1, TLastUpdate Stamp
FROM TableA
WHERE ID IN
  (SELECT ID FROM TableB b JOIN TableC c ON c.ID = b.ID)

Resolution

Fixed Problem on 12/18/2002 in version 3.21 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap