View Incident Report

Serious

Reported By: Oliver Bock
Reported On: 12/18/2003
For: Version 4.01 Build 1

# 1519 Using SQL JOIN Clauses Without an Actual Join Expression Between the Two Tables Fails

The following query worked in v3.24, however in v4.01 DBISAM complains: 'Internal join error - JOIN clause expression
for table "B" is invalid'.

select *
from A
join B on B.version = 1

Comments and Workarounds

We cannot fix this because of the way joins are processed in 3.27 and 4.00 and higher. DBISAM must have at least one condition that is an actual join expression in a join.

Resolution

Cannot Fix Problem

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap