how to create a join among 4 qvds?

[#1]

I am trying to achieve  this

//sql

select 

table_1.a,

table_2.b,

table_3.c,

table_4.e

from table_1, table_2, table_3,  table_4

where

table_1.p = table_2.p and

table _2.q = table _3.q  and

table _3.r = table _1.r and

table_4.s = table_2.s

I know a way to achieve this qlikview using tables but I want to achieve this using qvds as the data is huge.

[Siva_Sankar]

Hi Urmil,

QVD is just storage of data in tabular format, so there is no change in syntax of joining table vs joining qvd.

Example:

Table:

Load

X,

Y,

Z

From abc.qvd (qvd);

Left Join Load

X,

D,

E,

F

From def.qvd (qvd);

Depending on the join that you want to perform, you can replace the join key word(LEFT,RIGHT...,)

-Siva

[jmvilaplanap]

Hi

It depends what do you want to do, but first of all, the key fields (to do the join) must to have the same name. And second, depends do you want to do. Automatically, this four tables will be linked by Qlik (associative logic) but if you need yo make joins (and to have one single table at the end), you will have several options

• Left Join
• Right Join
• Inner Join
• Outher Join

Here do you have an example: Understanding Join, Keep and Concatenate