Jointure deux table Qlikview

[#1]

hi,

I started with QlikView and i m looking for how I can join it between two tables
( nanturelle , left or right)

here is what i m doing now :

Pivot:

LOAD

    prnum;   

SQL SELECT

    prstatus.prnum,

    prline.prnum

    FROM  PRSTATUS prstat

        JOIN PRLINE pr

            ON pr.prnum = prstat.prnum;

thanks for help

--------------------------------------------------------------------------------------------------------------

Bonjour

je débute avec qlikview et je voudrais savoir comment je peut faire la jointure (nanturelle ou left ou right) entre deux tables

ci dessus le code que j exécute maintenat et ça marche pas

Merci

[er_mohit]

try like this

Temp:

load A,

B,

C ;

SQL seleect * from table;

inner join// if you want data between two tables

Test1:

load A,

B,

Z ,

D,

E;

SQL seleect * from table2;

hope it helps

[#3 · Accepted solution]

in qlikview if two tables have the common field name then both table are automatically linked .

example

suppose i have two table.

Table1
A	B
1	aa
2	cc
3	ee

Table2
A	C
1	xx
4	yy

here field A is common in both so this auomatocally linked,

now i think you want that,

select all from both table where Table1.A = Table2.A

then for this in qlikview we achieve by inner join.

Table1:

load *;

Sql select * from table1;

inner join

load*;

Table2:

Sql select * from table2;

Then output like this

A	B	C
1	aa	xx

hope with the help of this example you will solve your problem.

Regards

vishwaranjan

[#4]

thanks a lot for help but it dosn t work

"Échec de la connexion ODBC

SQL select * from prstatus"

[#5]

yes but when we need to do a left join or a right join we need join statement i think !!!!