Hi, I have used left outer join select a, b from tab1 , tab2 wher

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 / vijay_1994

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are analytical functions in sql?

1033

Can you join a table to itself?

1133

Can we use commit inside a trigger?

1094

What kind of join is join?

975

What is meant by temporal data?

971

Define overloaded procedure?

1085

How do you take the union of two tables in sql?

987

How can we make an if statement within a select statement?

1015

What is rownum in sql?

1046

What are the sql commands?

1184

How do rank () and dense_rank () differ?

1046

Is sqlite good enough for production?

996

Is sqlite free?

977

what are the advantages of mysql in comparison to oracle? : Sql dba

1004

How do I run pl sql in sql developer?

1120