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


Please Help Members By Posting Answers For Below Questions

What is rebind in db2?

783


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

984


What is schema in db2?

788


How does cobol compile db2 program?

822


What do you mean by commit and rollback?

780


How to view db2 table structure?

805


What are db2 tables?

869


is it compulsory commitment control in journal?

2239


How can we retrieve the total number of records in RPG & CLLE?

387


Name the lockable units in DB2?

909


How would the varchar column remarks defined?

856


What is dbrm in db2 database?

797


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2558


How to compare data between two tables in db2?

857


What is the use of predicate?

794