Join Table Syntax

[zahidrahim_ocp]

Dear Experts,

I am very much new to Qlik. I have seen tables join syntax using Left OUTER Join RIGHT JOIN etc. Can we use Oracle Join Syntax which is something like below

table1.column = table2.column(+)

If yes then can i have specimen code for it.

Regards,

Zahid Rahim

[vinieme12]

With Qlikview you don't need to specify the column names to join on, Qlikview will automatically join on common field names between the tables

if you still want to use your existing SQL statement then use a SQL SELECT clause as below for example

Tab1:

Load *;

SQL SELECT Order, Item, Date

FROM TABLENAME WHERE  <Your condition>

[zahidrahim_ocp]

Can i join more tables in a script with join conditions something link below.

table1.column = table2.column(+)

table1.column = table3.column(+)

[ahaahaaha]

Hi,

If I correctly understood the code Oracle (I'm not an specialist in Oracle, the Internet is in the help).

Source code Oracle looks something like this

select * from TABLE1 "table1", TABLE2 "table2"
where
  table1.column = table2.column(+)
and table1.column = table3.column(+)



The same code of Qlik script (tables сonsider as internal) will be like this

Table:

LOAD

column

Resident table1;

Left Join

LOAD

column

Resident table2;

Left Join (Table)

LOAD

column

Resident table3;

You can not use directly this (above) expression  in Qlik.

Regards,

Andrey

[arvind_patil]

Hi zahid,

Please refer the below link It will help you:

qlikview join vs sql joins

Thanks,

Arvind Patil