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

Why do we need pl sql?

1037

Whis is not false in primary key?

1522

How many types of triggers are there in pl sql?

1119

What is left inner join in sql?

1094

How much does sql cost?

1067

Why is stored procedure faster than query?

1021

What are the sql versions?

999

What are local and global variables and their differences?

1140

What are data types in pl sql?

1197

What is pl sql in oracle?

1099

Are dml statements autocommit?

1095

What is pl sql code?

1106

What does the hierarchical profiler does?

1126

what is the difference between a having clause and a where clause? : Sql dba

1157

What is write ahead logging in sql server?

1101