What technique is used to retrieve data from more than one
table in a single SQL statement?
- 9 Answers
- 12980 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 db2 restart?
What are iseries servers?
Define sqlca.
Explain db2.
What does sqlcabc has?
What is the physical storage length of timestamp data type?
How to connect to db2 database from windows command line?
What is cascading rollback?
What is the picture clause of null indicator variable?
List out the data types available.
How do I add a column to a table in db2?
What are bind parameters in db2?
What are host variables in db2?
What is dclgen in db2?
What is a storage group (stogroup)?
