select * from tab1 union select * from tab2;

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

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

Answer Posted / geeta

select * from tab1
union
select * from tab2;

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different types of functions in sql?

1004

What is the sql case statement?

1007

What is the difference between a primary key and a clustered index?

993

What makes a good primary key?

1042

What are all the different normalizations?

1032

Is truncate ddl or dml?

991

Is oracle and sql same?

1013

What is a sql schema used for?

1104

How to order siblings in oracle hierarchy queries?

1047

Why are indexes and views important to an organization?

958

Do ddl statements need commit?

973

What are sql objects?

1081

How to process query result in pl/sql?

1128

what is query cache in mysql? : Sql dba

1036

How do you know if a relationship is 2nf?

946