I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

Question Posted / rashmi

4 Answers
8403 Views
GE, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the ..

Answer / rizaul

I have used inner joins

Is This Answer Correct ?

6 Yes

0 No

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the ..

Answer / geeta

select * from tab1
union
select * from tab2;

Is This Answer Correct ?

3 Yes

2 No

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the ..

Answer / vijay_1994

Hi,
I have used left outer join
select
a,
b
from
tab1 ,
tab2
where
tab1.a = tab2.b(+);

Is This Answer Correct ?

0 Yes

0 No

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the ..

Answer / anil

I prefer full outer join MINUS inner join.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer