I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p
if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately
Can anyone help on this?

Question Posted / mehul.thakur

2 Answers
6152 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p ..

Answer / ankit sinha

equijoin will produce only the common record.
A right outerjoin B will produce all common records with
remaining records from B . The point to be noticed here is A
is right outerjoined to B which means common records from A
as well as remaining records from B

Opposite things happen with A left outerjoin B

Full outer join means common records and remaining records
from both the tables

crossjoin means multiplications
suppose A has 4 records and B has 4 records.
Total output will have 16 records.

Is This Answer Correct ?

7 Yes

0 No

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p ..

Answer / mandayan

not pasible to help u becouse u have to give with data ok

Is This Answer Correct ?

1 Yes

1 No

Post New Answer