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

9 Answers
15775 Views
CTS, IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / ravi

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

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is database manager in db2?

1025

What is the use of dclgen in db2?

1085

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3218

How to check last update on table in db2?

1062

What is the syntax for creating a table in the db2 database?

1109

What are types of indexes?

1079

What is sqlca?

1081

What is ibm db2 client?

944

Before you give the explain statement, what are the prerogatives?

1044

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What is a db2 tablespace?

1069

What is db2 bind process?

1244

How many databases are there?

1060

What is the maximum length of sqlca?

1531

what is the responsibility of the construction superintendent

2149