I prefer full outer join MINUS inner join.

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

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

Answer Posted / anil

I prefer full outer join MINUS inner join.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the limitations of identity column? : Transact sql

1161

Explain architecture of sql server notification services?

1107

What is pls integer?

1090

What is coalesce sql?

1052

what is column? : Sql dba

1050

What is sql dialect?

1175

How do I run a sql query in pgadmin 4?

999

how to check myisam tables for errors? : Sql dba

1393

What does pragma mean?

1130

How many primary keys can a table have?

1057

What is the difference between sql and mysql?

1174

Is sql a oracle?

1022

how can we destroy the cookie? : Sql dba

1081

What is the maximum number of rows in sql table?

1075

What is the sql query to display the current date?

1092