Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is a sql profiler?

1066


Are sql connections encrypted?

1085


Why is theta join required?

1188


explain commit and rollback in mysql : sql dba

1076


Explain the significance of the & and && operators in pl sql.

1048


What does dml mean?

1043


How do you delete data from a table?

1098


What are the different schemas objects that can be created using pl/sql?

1085


Which certification is best for sql?

1041


What is a sql trace file?

1085


What does subquery mean in sql?

1114


How do I find duplicates in a single column in sql?

1068


what is sql profiler? : Sql dba

1115


What are pl sql procedures?

1079


Can we write dml inside a function in sql server?

1004