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

What is secondary key?

880

What is the size of partition table?

987

What are the different ways to optimize a sql query?

888

How can we solve sql error: ora-00904: invalid identifier?

1159

What are the rules to be applied to nulls whilst doing comparisons?

1268

Define join and name different types of joins?

955

what are dynamic queries in t-sql? : Transact sql

957

Is big data nosql?

881

what is the difference between delete and truncate commands? : Sql dba

990

What is a null value?

1077

What is view explain with example?

879

Write a sql query to find the names of employees that begin with ‘a’?

950

what are aggregate and scalar functions? : Sql dba

990

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3007

what are all the common sql function? : Sql dba

1009