Icon View Incident Report

Serious Serious
Reported By: Oliver Bock
Reported On: 7/8/2004
For: Version 4.08 Build 1
# 1772 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 4.09 build 1