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?
- 9 Answers
- 15773 Views
- CTS, IBM, TCS, I also Faced
- E-Mail Answers
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
i want to maintain uniqueness on pdf without make lf??????????
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Can there be more than one cursor open for any program?
Discuss about db2 bind?
Why do we use cursor?
What is rebind in db2?
Which command is used to remove all rows from a table?
What is view db2?
What is dclgen (declaration generator)?
Comment whether the cursor is closed during commit or not.
What is the clustering index in the db2 database?
Which component is responsible for db2 startup and shutdown?
What is bind and rebind in db2?
How to restart a DB2 program?
How can you quickly find out the # of rows updated after an update statement?
