View Incident Report

Serious

Reported By: Guenter Angerer
Reported On: 3/26/2001
For: Version 2.08 Build 1

# 767 Using an SQL NOT IN Clause with Multiple Columns from Multiple Tables Fails with Error

The following SQL will cause an #11949 "Internal Table Filter Error":

SELECT *
FROM tablea a
INNER JOIN tableb b
INNER JOIN tablec c
INNER JOIN tabled d
WHERE a.field1+b.field1+c.field1 NOT IN
   (SELECT (field1+field2+field3) AS test FROM lookup)

Resolution

Fixed Problem on 3/28/2001 in version 2.09 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap