Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Creator III
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
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

View solution in original post

6 Replies
Highlighted
Specialist II
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

View solution in original post

Highlighted
Partner
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
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
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

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 ATable BResult
IDDataAIDDataBIDDataADataB
1A1D1AD
2B1E1AE
3C1F1AF
2B
3C

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

Highlighted
Creator III
Creator III

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