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
10117 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

Explain locks? : Transact sql

1053

Are sql database names case sensitive?

1052

what are all the common sql function? : Sql dba

1102

When are we going to use truncate and delete?

1022

Which is faster count (*) or count 1?

1088

When to use inner join and left join?

1013

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1033

How run sql*plus commands that are stored in a local file?

1113

Can we use pl sql in mysql?

1063

what are all types of user defined functions? : Sql dba

1085

How do you determine the current isolation level? : Transact sql

1203

Can we use loop in sql?

1010

Which is better varchar or nvarchar?

1050

What is scalar data type in pl sql?

1114

What does where 1 1 mean in sql?

1075