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 / sunil

JOIN: You can join the 2 tables on tables primary key or on
the filed which refers to another table

UNION: In both table while doing UNION the filed name
should be same.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does a COMMIT statement do?

1331


What is the difference between a schema and a subschema?

1834


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

768


Explain storage architecture of idms.

792


What is a set in idms? What pointers are required, what are possible? How may sets be ordered?

796


What is integrated data dictionary?

872


How may sets be ordered?

833


What is a run unit?

1353


Explain about logical data model of idms?

829


What does a store statement do?

1488


What is an area sweep?

832


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

766


What is a bind in idms?

816


How can we debug cobol pgm containig idms using xpeditor?

1462


Explain about area currency?

794