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
What is precompiler in db2?
How does a cursor work?
What is the purpose of using commit?
What is database manager in db2?
What is lock escalation in db2?
What is node in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is explain in db2?
Name the lockable units in DB2?
What is dbrm?
Explain about open switch business continuity software?
Discuss about db2 bind?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Which isolation level provides highest data integrity?
How to rename a table in DB2 ?