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 the difference between explicit and implicit cursors in oracle?

496

What is sql comments?

642

How does a trigger work?

524

explain the options of myisamchk to improve the performance of a table. : Sql dba

532

How do I view an execution plan in sql?

516

What are synonyms in sql?

523

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

536

What is tuple in sql?

531

Describe sql comments?

543

How to display the current date in sql?

585

Is primary key clustered index?

508

Show how functions and procedures are called in a pl/sql block.

575

How to get help at the sql prompt?

624

What do we need to check in database testing?

544

Why having clause is used in sql?

523