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 the difference between a schema and a subschema?

1838


Is there a application program coding difference between local and central version mode in idms?

809


Explain the difference between record occurrence and record type?

2016


What methods are available for persisting records in an idms database? Explain.

770


What are the types of record locks and how are they set?

1553


What is the idd in idms?

1008


What are IDMS set of occurances?

1285


So manual and automatic are the connect options for a set. What are the disconnect options?

765


What is the function of commit in idms?

799


What is the difference between an obtain next and obtain first in idms?

826


What does a rollback do in idms?

907


Explain about find and obtain commands?

872


Explain about set currency?

806


what methods are available for persisting records in an idms database?

777


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

771