What technique is used to retrieve data from more than one
table in a single SQL statement?

Answer Posted / karthik

select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st> join <Table name2nd> where
table1.columnname = table2.columnname;

atleast one column should be unique in both the tables.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is precompiler in db2?

810


How does a cursor work?

783


What is the purpose of using commit?

865


What is database manager in db2?

791


What is lock escalation in db2?

809


What is node in db2?

836


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

869


What is explain in db2?

810


Name the lockable units in DB2?

928


What is dbrm?

885


Explain about open switch business continuity software?

864


Discuss about db2 bind?

895


What is the cobol picture clause of the db2 data types date, time, timestamp?

860


Which isolation level provides highest data integrity?

839


How to rename a table in DB2 ?

850