Icon View Incident Report

Serious 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 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 Resolution
Cannot Fix Problem