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

Which nosql database is best?

923

What is difference between mysql and postgresql?

1042

what is view? : Sql dba

911

Define sql delete statement.

952

What is the purpose of primary key?

965

what is error ora-03113: end-of-file on communication channel?

1081

Describe types of sql statements?

989

Is pl sql better than sql?

978

How to run sql statements through the web interface?

983

How to know the last executed procedure?

1031

How do you clear the screen in sql?

1009

What does the file extension accdb stand for?

915

What does varchar include?

905

What are different functions in sql?

896

Is subquery faster than join?

950