Reported By: Oliver Bock Reported On: 7/8/2004 For: Version 4.08 Build 1
# 1772Specifying 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
ResolutionFixed Problem on 8/10/2004 in version 4.09 build 1