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
- 15688 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 are host variables in db2?
How to check last update on table in db2?
Explain packages.
Define check constraint.
What is host variable?
What is dbrm? When it will be created?
How is deadlock resolved?
List out the data types available.
What is meant by union and union all?
What is clone table?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Explain correlated sub-queries.
What is the role of schema in the db2 database?
How to check table size in db2 sap?
What is the usage of open cursor command?
