left join

[#1]

hi

There is three tables -A with 25 records,B with 15 records and C with 30 records. And you are doing Left Join Between A and B  , right join between B and C . What would be the end result?

[MK_QSL]

First you are doing Right Join B - C.... There are 30 records..... drop table C..

Now A - B left join... Drop table B... 25 records...

[ashfaq_haseeb]

You will have 30 rows.

Have a look at below post

QlikView Joins

regards

ASHFAQ

[maxgro]

I think it depends on the values of the fields used for the joins.

Are they all distinct?