database join condition


#1

I have two tables where where the join condition is an inequality

so something like

Table A:

id size
a 3
b 10
c 11388

Table B:

id size
a 2
b 12
c 387

join condition
A.id = B.id
A.size < B.size,

which should pick out b only

at the moment the join conditions in the join node are all equality, is there a simple way to inequality joins?

David


#2

Hi,

I think the nature of joining is on a shared value in both tables.
But I have a suggestion for you:
Just simply use the “Rule-based Row Filter” node to filter the new table based on your second condition.

Best,
Armin