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

how to create a new table in mysql? : Sql dba

986


List the ways to get the count of records in a table?

900


What are joins in sql?

1044


can a stored procedure call itself or recursive stored procedure? : Sql dba

1028


what is a composite primary key ? : Sql dba

1050


How many sql core licenses do I need?

944


How do I edit a stored procedure?

992


What is sqlcontext?

1082


What is embedded sql what are its advantages?

1041


What are the steps for performance tuning.

1335


How to raise user-defined exception with custom sqlerrm ?

1129


Is left join inner or outer?

1014


What is the main difference between sql and pl/sql?

1094


What is schema in sql example?

1178


What is bitemporal narrowing?

1308