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

What is the difference between join and union.

Question Posted / vinay shukla

Answer Posted / vinay shukla

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

Is This Answer Correct ?

60 Yes

20 No

Please Help Members By Posting Answers For Below Questions

Can there be more than one function with a similar name in a pl/sql block?

985

What are different types of sql?

1192

What are the ddl commands?

1012

What are the differences between implicit and explicit cursors?

1071

What is group by in sql?

1085

How show all rows in sql?

1015

What is sql*loader and what is it used for?

1155

what is schema? : Sql dba

1051

What is normalisation in sql?

1064

Enlist the advantages of sql.

1001

Describe types of sql statements?

1060

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1118

What are the benefits of triggers?

1174

How to prepare for oracle pl sql certification?

1069

What is the difference between the sql*loader and import utilities? : aql loader

1043