Or condition during joining 2 tables in qlik sense

[svinnakota]

Hi All,

Sql: select a,b,c from table1

left join

(select c,d,e from table2)t2

on (b>d or a=e)

How to write the above joining condition in qlik sense script.

Thanks in advance,

Santosh

[agigliotti]

tab1:

sql select a,b,c from table1;

left join

sql select c,d,e from table2;

tab2:

noconcatenate

load * resident tab1 where b>d or a=e;

drop table tab1;

[handry_orozco]

Hi

Try this,

Select Table1.A,

           Table1.B,

           Table1.C,

           Table2.D,

           Table2.E

From Table1

Left Join Table2

On B >D

Or  A = E