c-treeACE V10.3 Release Notes

SQL - Wrong query result when mixing inner and outer joins

Queries of the following form were found to return incorrect results if there was a complex join condition or a predicate between tbl2 and tbl3:

(tbl1 LOJ tbl2) Inner Join tbl3

The logic has been modified to correctly address this situation.