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 iseries database?
How to rename a table in DB2 ?
Which component is responsible for processing sql statements and selecting access paths?
How is deadlock resolved?
What is netezza database?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is access path in db2?
How and when does the db2 enforces the unique key?
What is package in db2 mainframe?
What is the role of the data page in the db2 database?
What is the latest version of ibm db2?
What is buffer pool in the db2 database?
What is copy pending and check pending in db2?
What is db2 stogroup?
What's The Percentage Free Space ?