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

select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st>,<Table name2nd>;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When reorg is used?

1122


Explain about dbrm.

1037


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2231


Comment whether the cursor is closed during commit or not.

1093


What is role in db2?

1101


What is precompiler in db2?

1008


What are iseries servers?

1068


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1183


Is db2 a mainframe database?

992


Where can you declare a cursor in a cobol-db2 program?

1067


What does runstats do in db2?

1099


What are types of indexes?

1060


what is the responsibility of the construction superintendent

2139


What is the syntax for FETCH in DB2 ?

1201


What is the role of the data page in the db2 database?

1018