What is the difference between join and union.
Answer Posted / uchit shah
A Union and Join are similar in that they both are combining
two tables to form another table. However they do this
combining in different ways. The geometry is different.
Lets say for Table A and Table B
Union : -
|A|
-
|B|
-
Join : - -
| A | B |
- -
Union :
(1) In Union Two Rows of one table must fit onto the other
table. The Number of columns in the result table is the same
as the number in both tables. No new Columns are added.
(2) Maximum Number of rows = Sum of Number of rows in the
two tables.
Join :
(1) In Join the rows of one table may be different from the
rows of another table. The result table can contain columns
from both the first and second tables. It can contain all
the columns of first table and all the columns of second tables.
(2) Maximum Number of rows = Product of rows in two tables.
Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
how to fetch common records from two tables? : Sql dba
how many sql dml commands are supported by 'mysql'? : Sql dba
How can we avoid duplicating records in a query?
What are primary key and foreign key and how they work?
What is 19 null in sql?
How do I count records in sql?
Which is better join or inner query?
What are data types in pl sql?
Does sql*plus also have a pl/sql engine?
Can you join a table to itself?
what are local and global variables and their differences? : Sql dba
Can we join two tables without common column?
Can we use view in stored procedure?
Can two tables have same primary key?
What are the two characteristics of a primary key?