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 technique is used to retrieve data from more than one
table in a single SQL statement?

Answer Posted / anjireddy vintha

By using JOINS and UNIONS we can retive data from
morethan one table.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List down the data types in the db2 database.

1041


What are the 2 sqlcodes that are returned?

1129


How do you concatenate the firstname and lastname from emp table to give a complete name?

1011


What is a bind card?

1141


What action db2 takes when a program aborts in the middle of a transaction?

1088


What is schema in db2?

962


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1660


What is rebind in db2?

999


How to check sequence on a table in db2?

994


What are the prerogatives?

1014


What is image copy in db2?

944


How would the varchar column remarks defined?

1036


What is ibm db2 client?

880


What is db2 bind process?

1179


Explain package in db2 and its advantages?

1134