Correct Join Handling in Queries

The c-treeSQL Server failed to execute a particular class of SELECT queries containing a join resulting in error 20008. A particular optimization strategy failed to produce the correct output. The query optimization logic was adjusted to use an appropriate optimization for this type of query.