What is the difference between join and union.
Answer Posted / viswanath
Both of them are two different operations, but both are
used for merging. However, UNION used for Vertical merge
where as JOIN used for Horizontal merge.
We can never use these two distinct operations
interchengably.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is synonyms?
How to run sql commands in sql*plus?
how can we know the number of days between two given dates using mysql? : Sql dba
What is procedure explain with program?
How many types of indexes are there in sql?
What are the different types of a subquery?
What is a boolean in sql?
How does left join work in sql?
what is acid property in database? : Sql dba
How do I trace sql profiler?
How do you modify a table in sql?
What is cte?
What is the difference between a procedure and a function?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is the use of index in sql?