SELECT a.*
FROM TABLE4 a
INNER JOIN TABLE5 d ON T4_SFLD1 = T5_SFLD1, TABLE2 b
LEFT OUTER JOIN TABLE1 c ON c.T1_KEY = b.T2_KEY1
WHERE a.T4_KEY = c.T1_SFLD1 AND a.T4_KEY = 'Abbott'

---

 Comments

---

This query was from the Advantage Database benchmarks posted on their site. It's not a very likely scenario since the result set is 8000+ empty rows. Basically the problem was that the ordering of the joins confused DBISAM's internal join re-ordering code.

---

 Resolution

---

Fixed Problem on 11/8/2001 in version 3.04 build 1