We can do this by using JOINS as well as Sub Queries

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

Question Posted / ravi

Answer Posted / ravi

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is bind package and plan in db2?

1004

What are bind parameters in db2?

980

What is meant by union and union all?

948

What is cursor stability in db2?

1276

What is runstats and reorg in db2?

1236

How do I copy a table in db2?

950

What is consistency token in db2?

1061

What is explain in db2?

958

How does cobol compile db2 program?

1005

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

1180

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3519

What is the difference between drop table and delete table?

1116

What is rct?

1163

What language is db2 written in?

980

What is bind in db2?

975