select <column name of 1st table>,<column name of 2nd table>

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

Question Posted / rahul

Answer Posted / rahul

select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st>,<Table name2nd>;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What language is db2 written in?

980

What is isolation level in db2?

941

What is db2 bind process?

1179

Explain db2.

991

When the like statement is used?

1156

What is database alias db2?

1066

Why do we need reorg in db2?

922

What is the physical storage length of the data types date, time, and timestamp?

1039

What is copy pending status in db2?

1068

Explain the benefits you can get from mainframe connect?

910

Are view updateable?

980

What is the purpose of using commit?

1040

What is the result of open cursor statement?

1028

How connect db2 database to datastage?

1187

what is utility for parm lib

2309