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 are the types of sql commands?

1105


Give the order of sql select?

1141


How do I view a sql trace file?

1035


how do you know the version of your mysql server? : Sql dba

1007


Can a varchar be a primary key?

1012


Are stored procedures faster than dynamic sql?

1047


What is trigger in sql? Explain

999


What is the difference between cross join and natural join?

1028


Explain the savepoint statement.

1102


What are the differences between implicit and explicit cursors?

1071


Why schema is used in sql?

1056


What is scope of pl sql developer in future?

1026


Explain unique key in sql.

1017


Can we create a trigger on view?

901


Explain the steps needed to create the scheduled job?

1042