help in converting SQL OR condition in QV script joins

[ankitasinghal]

Hi Geeks,

I have below requirement

suppose we have 4 tables A, B,C,D

and I have below SQL query i want convert this query in QV kindly help me in this.

in below SQL query i am not able to write QV logic for ((A.col2=D.col2) or (B.col2 is null))  or condition.

SQL query.

select *

from table A left join table B

on  A.col1=B.col2

left join C

on A.col1=C.col1

left join D

on

A.col1 =D.col1

and ((A.col2=D.col2) or (B.col2 is null))

Thanks,

Ankita Singhal

stalwar1‌

[tripatirao]

Hi,

Try to make 4 tables in excel by taking some sample data.

Load these table into qlikview and try to join

[chinnuchinni]

you can easily achieve this with the preceding load.

just give the same name to the fields  to join the tables.

if you need proper solution please attach the sample data and your required o/p.