we can join two tables by 'join' if they have common field.we c

What is the difference between join and union.

Question Posted / haritha

Answer Posted / haritha

we can join two tables by 'join' if they have common
field.we can union two tables irrespective of common field.

Is This Answer Correct ?

316 Yes

148 No

Please Help Members By Posting Answers For Below Questions

What is restrict in sql?

1177

what is the bond code in materialized view?

3059

Explain about various levels of constraint.

1000

Can we use join in subquery?

1150

What is pl sql architecture?

1002

What is query execution plan in sql?

1249

Is pl sql different from sql?

1043

What are the two types of cursors in pl sql?

1123

Why use subqueries instead of joins?

1135

How do you delete a table?

1124

Why do we need unique key in a table?

1004

What is the difference between join and natural join?

984

What is difference between my sql and sql?

1138

What is sql resultset?

1040

How to avoid duplicate records in a query?

1053