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 phantom read in db2?

1082

How can you do the explain of a dynamic sql statement?

1027

What is with ur in db2?

1255

What is a dbrm in db2?

976

What is explain plan in db2?

947

Is ibm db2 open source?

1027

What are union and union all?

934

Define buffer pool.

1005

What action db2 takes when a program aborts in the middle of a transaction?

1104

What is the difference between drop table and delete table?

1131

Where can you declare a cursor in a cobol-db2 program?

1011

What is host variable?

1021

What is temporal table in db2?

994

What is the use of commit in db2?

1012

Is db2 a mainframe database?

954