Cartesian join under condition

Fri, 29 May 2015 07:39:08 GMT

Dear Community,

I would like to create a table, which is a result of cartesian join of two tables under specific condition.

Let's say my SQL code looks like:

select a.OFFER_ST,a.OFFER_END,
b.MONTH_ST, b.MONTH_END, b.MONTH
from CP a, CP_K b
where (a.START_CA between b. MONTH_ST and b.MONTH_END) or (b. MONTH_ST between a.START_CA and a.END_CA);

Is it possible to do this in Qlikview in a similar way?

Thank you for your help in advance!

topic Cartesian join under condition in QlikView

Cartesian join under condition