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
- 15748 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
What is a plan and package in db2?
Where do you specify them?
How do you eliminate duplicate values in db2?
What is dbrm? What it contains? When it will be created?
What are the contents of a dclmgen?
What is a buffer in memory?
How do I connect my db2 database to ibm?
How to check sequence on a table in db2?
What is the maximum size of varchar data type in db2?
Can one database have multiple instances?
What is iseries database?
Comment whether the cursor is closed during commit or not.
Explain the function of data manager.
What is the difference between using bind () and rebind () methods of naming class?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
