What technique is used to retrieve data from more than one
table in a single SQL statement?
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 rebind in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is schema in db2?
How does cobol compile db2 program?
What do you mean by commit and rollback?
How to view db2 table structure?
What are db2 tables?
is it compulsory commitment control in journal?
How can we retrieve the total number of records in RPG & CLLE?
Name the lockable units in DB2?
How would the varchar column remarks defined?
What is dbrm in db2 database?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How to compare data between two tables in db2?
What is the use of predicate?