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
10119 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

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

1016

What is a natural join?

1140

What are schema-level triggers?

1151

Is it possible for a table to have more than one foreign key?

1080

Is left join and outer join same?

1114

What is the clause we need to add in function body to return variable?

1052

What is difference between table and view?

1134

How does left join work in sql?

1039

Why do we use triggers?

1015

Describe types of sql statements?

1103

How can you know that statistics should be updated?

1128

Is crud a cuss word?

1073

Can I join the same table twice?

1095

What is the difference between delete, truncate and drop command?

1225

What is right join sql?

1013