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

Is ibm db2 open source?

1075

Which component is used to execute the sql statements?

1096

Define sqlca.

1108

What is a db2 table?

1015

How do I delete a column in db2?

1109

Define db2 and its databases?

1055

What is difference between alias and synonym in db2?

1141

How can you classify the locks in db2?

1089

When do you specify the isolation level?

1030

What is db2 command?

1036

Mention some fields that are a part of sqlca.

1033

What is the use of db2 optimizer?

1114

Explain the function done by data manager?

1280

Explain the function of data manager.

1044

Which components manage deadlocks in db2?

1071