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.

[#2]

ThanQ

[#3]

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

[Anonymous]

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.

[maxgro]

and if all the common records have the same values?

Table A

1

1

1

1

1

2

3

4

5

6

Table B

1

1

1

1

1

10

11

..

..

[Anonymous]

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