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 / ananda kumar

join retrive the data more than one table using single sql
query where as union combine the results of two or more sql
queries.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you use max on a char column?

1031


What is the maximum number of columns in a db2 table?

1215


Explain how can you do the explain of a dynamic sql statement?

1066


Define db2.

1067


What is dclgen in db2?

1084


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9002


Can one database have multiple instances?

1008


Is ibm db2 open source?

1016


What is a bind card?

1145


What is temporal table in db2?

990


How can record locking be achieved in those DB2 versions which do not support it?

1021


What does db2 stand for?

961


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1007


What are the bind parameters ibm db2?

991


How is deadlock resolved?

1082