Icon View Incident Report

Serious Serious
Reported By: Oliver Bock
Reported On: 7/8/2004
For: Version 3.29 Build 1
# 1817 Specifying SQL JOIN Conditions On Tables Not Involved in the JOIN Directly Causes AV

DBISAM crashes when I attempt a particular join. I can work around it by swapping the two tables in the FROM clause.

select * 
from GLNew mN, SystemGLAccount SA
join PaySlip PS on mN.SourceID = PS.PaySlipID
join Tax T on SA.PAYGTaxID = T.TaxID

Resolution Resolution
Fixed Problem on 8/10/2004 in version 3.30 build 1