UNION could be used to retrieve data from more than one table as well.

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

Question Posted / biryuk

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

Answer Posted / biryuk

UNION could be used to retrieve data from more than one
table as well.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2007

What is a cursor in programming?

1013

List some fields from sqlca?

1000

What is drop table?

958

What is the use of db2?

1005

What is dbrm? What it contains? When it will be created?

991

What is runstats utility in db2?

961

Who uses db2?

981

i want to maintain uniqueness on pdf without make lf??????????

2097

What are the rules for db2 programming?

1040

What is cloudant database?

1032

What is null indicator in cobol db2?

991

What are the various data types available in db2?

1011

What is null value in db2?

949

What are the uses of db2 optimizer?

1222