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
9711 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 is pragma in sql?

1020

What is normalization in a database?

1104

Is join and inner join the same?

940

Explain dml and ddl?

919

What is trigger in pl sql?

954

Is pl sql better than sql?

976

Are sql connections encrypted?

952

Is left join same as join?

936

what are tables and fields? : Sql dba

987

What is PL/SQL Records?

1113

What is rownum and rowid?

982

What is rtm stands for?

1020

What is sql*loader and what is it used for?

1044

What are the types of keys?

926

How do I run a query in pl sql developer?

925