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 / suresh ramaiyan

Join is used retrive the data from two or more tables.
Union is used to join the result of two queries.

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a page in db2?

1027


What is clone table?

1052


What is reorg?

1164


Explain about rct.

1092


How can the duplicate values be eliminated from db2 select?

1106


What is concurrency?

1238


What is the use of reorg in db2?

1087


How do I delete a column in db2?

1112


Outputs of explain are with matchcols = 0. What does this signify?

1062


How to fetch the last row from the table in SQL (db2)?

1657


How do you pull up a query which was previously saved in qmf?

1154


What is sqlca’s maximum length?

1195


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2857


How to find primary key of a table in db2?

1066


Explain in brief how does db2 determine what lock-size to use?

1046