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

Explain about few error status codes of idms.

944


Explain the difference between local and central version operating modes?

888


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

935


What does a finish do in idms?

1008


What is a set? How may sets be ordered?

901


Explain storage architecture of idms.

906


If the stored record is not defined as automatic of a set, how can it be stored as a member of the set?

867


What is an area sweep?

938


Explain about run unit currency?

955


Define a region in idms?

926


What is the copy idms subschema-binds in idms?

902


What is a set in idms?

912


What is a junction record?

1393


What is an ook-rec in idms?

933


Name and explain the three location modes?

1410