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
5924 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

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers Xansa,

How do you find the maximum value in a column in db2?

0 Answers

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers IBM,

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers

What is bind and rebind in db2?

0 Answers

What is precompiler in db2?

0 Answers

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers

Is db2 relational database?

0 Answers

How can you classify the locks in db2?