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's The Error Code For Unique Index Voilation?

1224

List some fields from sqlca?

1053

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

644

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1150

What is alias in db2?

1047

can we view the access paths created by dbrm ? how ? thx

7078

Differentiate between cs and rr isolation levels? Where do you specify them?

1065

What is the connection string to connect to the DB2 Database ?

1113

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1267

What is node in db2?

1038

What is multi row fetch in db2?

1043

what is diffrence b/w file-aid tool and file-aid utility???

4886

What kind of database is db2?

1030

How do I delete a table in db2?

1060

What is the difference between drop table and delete table?

1201