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

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers BNP Paribas,

How many databases are there?

0 Answers

Explain in brief how does db2 determine what lock-size to use?

0 Answers

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers Accenture,

What is difference between rollback and commit?

0 Answers

How to retrieve rows from a db2 table in embedded sql?

0 Answers

What is auditing?

2 Answers

Can we able to find all the Table names under a Particular Plan?

1 Answers CTS,

How do you define a correlated name?

1 Answers

How to check last update on table in db2?

0 Answers

How to define the data items to receive the fetch items for the SQL?

2 Answers

What is the SQL Communications Area and what are some of its key fields?

1 Answers

For more DB2 Interview Questions Click Here