Joins

[#1]

hi,

I am Kumar

I have 2 tables(those are Excel data)

Products:

Address	City	Fname	Lname	P_id
aavdvv	dfdvn	ola	Hansen	1
dbhg	fgeew	ccccccc	dddd	2
dvcd	dgghg	bbbbbb	aaaa	3

Orders:

O_id	O_no	P_id
1	234	4
2	345	3
3	456	1
4	678	1
5	898	2

These are the examle tables i have taken..

and how the differant types of joines are applied in Qlikview.In detailed.....

[ashfaq_haseeb]

Hi Ravi

Just go through the Document attached.

Hope that helps.

Regards

ASHFAQ

[#3]

hello

You will find about join types in QV Help(F1). It's with example and easy to understand.

[Miguel_Angel_Baeyens]

Hello,

First of all, QlikView's associative logic would say that if you have two tables with a field named alike with the same value (call it a Key field) tables are associated by those fields.

Meaning that if, according to your example above, you want to know the value of "O_no" for Address "dbhg" you don't need to do any additional joining, tables are linked automatically by their "P_id" field.

So in my case, without further requirements, I'd leave your tables as you already have it.

Hope that helps.