Hi all,

I am developing a process in which I have to perform a Join between Table A and Table B where a value from A has to be in a range of values stored in B.
In SQL something like this

select <projection>
from a
inner join b on a.column between b.range_start and b.range_end

I am forced to use a tMap component and I reckon this is not the way to go.

I could have easily used a tMap ELT but I am using pgSql and I don't have that component available (TOS 3.2.2).
I could use filtering condition, unfortunately this would mean generating a cartesian join: not feasable because the resulting dataset would be ~1000 rows from a cartesian of several millions.

Is there any other way?
The last chance would be to use an input component with an explicit join in the query but... not very clean.

Thanks
g