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

What are the benefits of pl/sql packages?

1107

Can primary key be changed?

903

Which version of sql do I have?

1054

Explain exception handling in pl/sql?

1033

Why do we use procedures?

955

Can you rollback after commit?

981

How do I remove sql plus from windows 10?

1096

Is left join and outer join same?

1057

What is a join?

1061

what is a constraint? : Sql dba

1163

what is dbms? : Sql dba

991

what are the properties and different types of sub-queries? : Sql dba

1033

What is mutating error in pl sql?

1013

What is trigger in pl sql?

993

What are the types of queries in sql?

1084