I have used inner joins

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

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

Answer Posted / rizaul

I have used inner joins

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are pl sql procedures?

1026

What is clause?

1151

Are stored procedures faster than dynamic sql?

1040

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1064

Is progress software supports to ( pl/sql )?

1039

What are packages in pl sql and also explain its advantages?

1040

What is exception? What are the types of exceptions?

1073

How do sql databases work?

1001

Can one improve the performance of sql*loader? : aql loader

1048

What is dense_rank in sql?

986

What is the difference between python and sql?

1005

What is field delimiter?

1048

What are the popular database management systems in the it industry?

1000

What is sql exception?

975

Can we use ddl commands in pl sql?

1162