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

[#1]

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.

[Anonymous]

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)

[Anonymous]

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.

[#4]

ThanQ Rajan

[#5]

Hi rajan

[Anonymous]

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

[#7]

ok

[Anonymous]

Hi Babu...tell me

[#9]

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

[Anonymous]

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)