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 / venki

A join is used to combine rows from multiple tables. A join
is performed whenever two or more tables is listed in the
FROM clause of an SQL statement.


Combines the results of two SELECT statements into one
result set, and then eliminates any duplicate rows from
that result set

Is This Answer Correct ?    40 Yes 57 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between sql and isql*plus?

1007


Why do we use sql constraints? Which constraints we can use while creating database in sql?

971


Is progress software supports to ( pl/sql )?

968


Is nosql faster than sql?

970


How to combine two stored procedures in sql?

1119


What is primary key sql?

951


Mention what is the function that is used to transfer a pl/sql table log to a database table?

932


What is the source code of a program?

1002


What is pl sql block in dbms?

949


Can I learn sql in a week?

1004


List the various privileges that a user can grant to another user?

988


Is sql procedural language?

919


What are the benefits of pl sql?

1052


How do I partition in sql?

904


What is column?

939