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 / lokesh chauhan

Join is used to established a conditional selection from 2
different tables, while union is used to select similar
data based on different conditions.

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2095


What is the role of the data page in the db2 database?

1027


Explain db2.

1033


Mention the location where the output received from explain statement is stored.

1127


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

1055


What do you mean by storage group (stogroup)?

1040


What is an instance in db2?

1033


What is a Foreign Key?

1095


Who uses db2?

1039


How to view db2 table structure?

1016


What is a cursor in programming?

1067


What is multi row fetch in db2?

1049


How do you stop a db2 database in linux?

1012


List down the types of triggers in the db2 database?

1026


How do you concatenate the firstname and lastname from emp table to give a complete name?

1075