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.
Answers were Sorted based on User's Feedback
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 |
What are %type and %rowtype for?
What is a trigger ?
11 Answers Accenture, BirlaSoft,
What is the difference between drop and truncate commands?
what are the different index configurations a table can have? : Sql dba
What is the example of procedure?
What are the types of index in sql?
What is sqlcontext?
What is relationship? How many types of relationship are there?
Is not equal in sql?
What is lookup table in sql?
What are few of the schema objects that are created using PL/SQL?
What is pl sql commands?