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?