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 difference between join and union?

Answer Posted / rajeev singh

Join display exact information from two or more tables.
and it is not compulsory in both table column equal.

Where as in UNION in both table column should be equal.
and union eliminate the dublicate rows.

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an ook-rec in idms?

804


What does a finish do in idms?

880


Define autostatus in idms?

774


Explain about logical data model of idms?

828


Explain the difference between a schema and a subschema in idms?

768


Explain the difference between record occurrence and record type in idms?

802


How can we debug cobol pgm containig idms using xpeditor?

1462


What is a run unit?

1350


What is dbkey? Explain.

788


When you are obtaining next within a set and get a end of set return code, on what record are you now current?

1324


How may sets be ordered?

831


What is ook-rec?

840


What is a bind in idms?

814


Define a junction record in idms?

789


Name and explain the location modes?

823