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!
