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
9717 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 the limitations of sql express?

988

what is a field in a database ? : Sql dba

991

Explain two easy sql optimizations.

962

What are the parts of a basic sql query?

920

How do you use collections in procedure to return the resultset?

2184

Do ddl statements need commit?

925

What is insert command in sql?

1061

What are the datatypes available in pl/sql ?

1045

How do I add a database to sql?

1064

What is the purpose of a sql?

915

What is acid property in a database?

974

how to start mysql server? : Sql dba

1147

Why we use cross join?

891

Which is faster union or join?

903

What are sql data types?

953