# PN5_60683

Updated: 1/18/2022, 5:31:44 PM
Created: 1/18/2022, 5:31:44 PM
Last Updated By: dependabot[bot]
Read Time: 1 minute(s)

# Description

SQL: JOIN issue, some JOINs would fail

# Previous Release Behavior

The issue seemed to be with JOINs on more than 2 tables and was dependent on the sequence of the limiters in relation to the sequence of the tables in the query.

# Current Release Behavior

We now check for situations where the data can't be limited for a given table because one of the limiting expressions has not yet been read. In this situation, the driver should switch to reading the join table sequentially and then continue to the next table in sequence.

Back to jBASE 5.7.0 Release Notes