A join selects columns from 2 or more tables. A union selects rows

What is the difference between join and union.

Question Posted / thangamadasamy

Answer Posted / thangamadasamy

A join selects columns from 2 or more tables. A union
selects rows

Is This Answer Correct ?

123 Yes

63 No

Please Help Members By Posting Answers For Below Questions

How to use distinct and count in sql query? Explain

601

What is procedure explain with program?

541

Why use subqueries instead of joins?

592

Why self join is used in sql?

485

How do I find sql profiler?

501

what are ddl statements in mysql? : Sql dba

568

Explain autonomous transaction.

628

Is it important to partition hard disk?

526

how many triggers are allowed in mysql table? : Sql dba

550

Does oracle roll back the transaction on an error?

524

How many types of tables are there?

496

Does mysql support pl sql?

613

What is an index in sql with example?

508

What is scalar function?

558

what are tables and fields? : Sql dba

569