joiner

Piet_Van_de_Weghe · March 7, 2019, 2:47pm

I want to join two tables, but I can only do an equal operator on the columns.
So for example
tab1.kol1 = tab2.kol1 AND
tab1.kol2 = tab2.kol2

But what if I want to
tab1.kol1 = tab2.kol1 AND
tab1.kol2 between tab2.kol2 and tab2.kol3

Doesn’t seem too exotic

Thx,
Kr,
Piet

izaychik63 · March 7, 2019, 3:05pm

After join on the first criteria you will need Rule-based Row Filetr

Piet_Van_de_Weghe · March 7, 2019, 3:16pm

Thx !
I’ll give it a go.
Kr,
Piet

mlauber71 · March 7, 2019, 9:18pm

If you want more complex joins you could also use SQLite so you can have a lot of SQL functions without having to install a SQL database.

Piet_Van_de_Weghe · March 7, 2019, 10:38pm

Thx a lot !
Kr,
piet