Joins result issue

[#1]

i have 2 tables .the first table consist of 20  records and second contains 30 records what would be the result if i apply left join ,right join,inner join and outer join.

Thanks & regards

raja

[marcus_malinow]

Raja,

this very much depends on the data itself, in particular which fields you are joining on.

Suggest that you take a look at this article - Different Join Functions in Qlikview

Also, use the search function before posting simple questions like this, you'll get an answer quicker and avoid spamming the board.

Marcus

[parthakk]

Hi Raja,

The result of join depends upon the similarity between your records/ fields. In general

Left join gives priority to left tables( say Table1)

Right join gives priority to right tables( say Table2)

Inner join fetches the value that are common in both the tables

Outer join combines both tables...

Thanks,

Partha Kulkarni

[Anonymous]

hi raja,

Please see below post:

Some Qlikview Joins best documents

left join loads all 20 records from first table and matching records from second table.

Right join loads all 30 records from second table and matching records from first table.

Inner join loads all matching records from first and second table  .

outer join loads all records from first and second table.

Regards

Neetha

[jonathandienst]

I suggest that you create a small qvw with in-line loads for two test tables and try out all the options yourself. If you work with that, the manual, existing articles and threads already in the forum and (as a last resort) specific questions on the forum, you will quickly master these concepts.