Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 179568 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / kamruddin saha
Join can be implemented different numbers of column where as
Union is implemented same number of column in different tables
Ex:- Table1 Contains 5 column and Table2 contains 8 columns.
So we can get data of 3 columns from Table1 and 4 Columns
from Table2 using JOIN.
But using UNION we can get same number of column from both
table.Like 2 columns from Table1 and 2 columns from Table2.
Thank You
| Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
what are numeric data types? : Sql dba
Are null values same as that of zero or a blank space?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is a native sql query?
Why stored procedure is better than query?
What is null in pl/sql?
How many clustered indexes can be created on a table?
what is foreign key? : Sql dba
What plvcmt and plvrb does in pl/sql?
What are string functions in sql?
State few characteristics of pl/sql?
Is primary key an index?
Explain the commit statement.
What do you understand by pl/sql records?
What is left join in sql?
