View Incident Report

Serious

Reported By: Rob Kittredge
Reported On: 12/7/1999
For: Version 1.19 Build 1

# 506 Mixing SQL SELECT LEFT OUTER JOINs and INNER JOINs Results in Improper Results

The engine does not return all the rows from the left side of the join as it should.

select * from "c:\rob.dat"
left outer join cntctdtl on customer_id = cntctdtl.customer_id
where cntctdtl.contact_date = null
order by customer_id

Resolution

Fixed Problem on 12/9/1999 in version 1.20 build 1

More Support Options