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
- 16009 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
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What os does db2 run on?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the advantage in De-normalizing tables in DB2?
How do you select a row using indexes in db2?
What does db2 mean?
Differentiate between cs and rr isolation levels? Where do you specify them?
is it compulsory commitment control in journal?
Explain about dbrm.
What is image copy in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is difference between rollback and commit?
What is db2 instance?
What is load utility in db2?
What is database alias db2?
