Let’s consider we have two tables (already loaded from a DB so DB nodes are not relevent here) to join. Table A contains an integer column X. Table B contains two integer columns Y and Z. We’re supposed to join rows from table A with rows from table B so that X value from table A is between values Y and Z of table B. An equivalent SQL select would be as follows: select * from A, B where A.X between B.Y and B.Z; Any idea how to achieve this? Thanks.

How to Join Two Tables Using a Condition with a BETWEEN clause

mlauber71 August 19, 2020, 5:40am 5

Maybe not the most creative idea but could you just load the two tables into a local SQL database like H2 (if it is in memory it might be fast) and just use the SQL code? And then download the results?

–
Edit: A BETWEEN Statement with H2 database

2 Likes