topic Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records in QlikView

f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Wed, 09 Sep 2015 19:07:17 GMT

HI, friends plz help me this,

if i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come .

note:in this two tables 5 records are comman records

a)if i do Right join How many records will come?

b)if i do left join how many records will come?

c)if i do inner join how many records will come?

d)if i do full outer join how many records will come?

plz help me friends.

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Anonymous — Wed, 09 Sep 2015 19:16:55 GMT

Table A=10 records Table B=25 Records 5 commmon

Table A left join Table B: 10

Table A right join Table B: 25

Table A inner join Table B: 5

Table A outer join Table B: 30 (25+10-5)

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Anonymous — Wed, 09 Sep 2015 19:21:55 GMT

I have answered your question above but it will be better if you create two tables, load them in qlikview and perform different joins. You will be able to see the result instantly and easily understand the concept. Let me know if you need any clarifications.

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Wed, 09 Sep 2015 19:29:16 GMT

ThanQ Rajan

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Wed, 09 Sep 2015 19:31:14 GMT

Hi rajan

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Anonymous — Wed, 09 Sep 2015 19:31:30 GMT

Babu: if I answered your question correctly, could you please mark it correct and close the thread. Thanks!

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Wed, 09 Sep 2015 19:36:27 GMT

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Anonymous — Wed, 09 Sep 2015 19:40:03 GMT

Hi Babu...tell me

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Wed, 09 Sep 2015 19:42:24 GMT

Hi Rajan, if i Don't have the common records there then what would be the answers for the same.

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Anonymous — Wed, 09 Sep 2015 19:50:05 GMT

Table A=10 records Table B=25 Records commmon: 0

Table A left join Table B: 10

Table A right join Table B: 25

Table A inner join Table B: 0

Table A outer join Table B: 30 (25+10-0)

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Wed, 09 Sep 2015 20:02:21 GMT

ThanQ

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Wed, 09 Sep 2015 20:07:24 GMT

Hi Rajan in full outer join how many records will come.

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Anonymous — Wed, 09 Sep 2015 20:09:40 GMT

Babu- in full outer join each record from both the tables A and B will be showing in a single table. In Inner join only common records will show. Hope it clears the doubt.

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

maxgro — Wed, 09 Sep 2015 20:10:05 GMT

and if all the common records have the same values?

Table A

Table B

Re: f i have 10 records in Table A and 25 Records in Table B If I join Table B To Table A How many Records will come . note:in this two tables 5 records are comman records

Anonymous — Wed, 09 Sep 2015 20:20:10 GMT

My answer was for Babu's question if there is no common record