What technique is used to retrieve data from more than one
table in a single SQL statement?

Answer Posted / rahul

select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st>,<Table name2nd>;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is access path in db2?

565


Is ibm db2 open source?

586


What is schema in db2?

576


What is package in cobol db2?

704


How to create backup table in db2?

644






Mention some fields that are a part of sqlca.

603


What is the syntax for FETCH in DB2 ?

675


Which components manage deadlocks in db2?

615


Are view updateable?

629


Define data page.

634


How to create db2 table in mainframe?

631


What are db2 tables?

649


Why cursor is used in db2?

576


What is runstats and reorg in db2?

800


What are iseries servers?

568