# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Creator III

## Logical Question

Hi Community,

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?

-- Regards,

Villyee Anderson

1 Solution

Accepted Solutions
Highlighted
Specialist II

Hi Villyee,

There will be 30 recordes.

from first join you will get 25 records

second will get 30 records

-- Regards,

Vishal Waghole

6 Replies
Highlighted
Specialist II

Hi Villyee,

There will be 30 recordes.

from first join you will get 25 records

second will get 30 records

-- Regards,

Vishal Waghole

Highlighted
Partner

Hi Villyee,

It depends on the column common between the tables.

If there is no common column, then it becomes a cartesian product. First join will result in 25x15=375 rows and Second join will result in 30x15=450 rows.

If there is a common column between the tables, then

First join will result 25 rows

Second Join will result in 30 rows.

Highlighted
Creator

Hi Villyee,

After apply the join condition in table A,B & C

A Left join B then you will get 25 records

and B Right join C then you will get the 30 records

Thanks

Highlighted
MVP

Join (SQL) - Wikipedia, the free encyclopedia

It depends on multiple factors like:

•      Number of fields in column between the two tables
•      Number of field values common
Highlighted
MVP

Hi,

You can know that the minimum will be 30 rows, in case there are no coincidences between tables. In other case it depends on coincidendes...

 Table A Table B Result ID DataA ID DataB ID DataA DataB 1 A 1 D 1 A D 2 B 1 E 1 A E 3 C 1 F 1 A F 2 B 3 C

If there are no coincidences, in left join Table A remains the same.

Highlighted
Creator III

Thank you all...........