What techniques are used to retrieve data from more than one table in a single

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

Question Posted / guest

2 Answers
6389 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What techniques are used to retrieve data from more than one table in a single SQL statement?..

Answer / obu

JOIN Statement

Is This Answer Correct ?

6 Yes

0 No

What techniques are used to retrieve data from more than one table in a single SQL statement?..

Answer / ezaz

joing

Is This Answer Correct ?

0 Yes

4 No

Post New Answer

More DB2 Interview Questions

Mention and explain the contention situations caused by locks?

1 Answers

Name the different types of Table spaces.

5 Answers IBM,

Are views updatable ?

4 Answers

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers

Explain about mirror activator disk mirroring?

0 Answers

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers

What is db2 and what is the use of db2 optimizer?

0 Answers

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

1 Answers

How to resolve -407 sql code in DB2?

9 Answers Cap Gemini,

Where is the output of EXPLAIN stored?

2 Answers

Define declaration generator (dclgen).

0 Answers

What can the Locate option of the Repair Utility accomplish?

2 Answers

For more DB2 Interview Questions Click Here