By using JOINS and UNIONS we can retive data from morethan one table.

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

Question Posted / anjireddy vintha

Answer Posted / anjireddy vintha

By using JOINS and UNIONS we can retive data from
morethan one table.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between cursor stability and repeatable read isolation levels?

1141

What is check constraint in db2?

1029

How to fetch the last row from the table in SQL (db2)?

1610

How do we specify index to include or not during bind process.

2088

What is the physical storage length of date data type?

1207

What is db2 bind process?

1202

What is multi row fetch in db2?

1010

List out the buffer pools in db2

1043

Explain the benefits you can get from mainframe connect?

931

How can you classify the locks in db2?

1053

Which is faster delete or truncate?

1088

What is query_cache_limit?

941

Discuss about db2 bind?

1064

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1060

On which levels locks can be applied?

1080