We are trying to find the best way to join two tables (A and B) with a join condition that requires to match a date (in table A) between two dates (in table B).
We saw that the joiner node does not allow to match columns in other way than exact match.
We cannot use cross / cartesian joins because the two tables are quite big in volume.
Could you suggest a solution, please?
Thanks a lot for you help.