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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the difference between join and union.

Question Posted / viswanath

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 constant in pl sql?

967

how to use in conditions? : Sql dba

958

What is parallel hint?

1220

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

942

Explain the insert into statements in sql?

936

What version is sql?

964

How do I view a view in sql?

889

how to check server status with 'mysqladmin'? : Sql dba

1012

How to run sql functions in pl/sql?

989

What is a subquery in sql?

975

what is view? : Sql dba

912

Explain the select statement in sql?

1044

What is sql performance tuning?

867

What is a temp table?

948

what are date and time data types? : Sql dba

930