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 / karthik

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

Answer Posted / karthik

select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st> join <Table name2nd> where
table1.columnname = table2.columnname;

atleast one column should be unique in both the tables.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention the various locks that are available in db2.

984

List down the types of triggers in the db2 database?

976

Is db2 a mainframe database?

954

What are iseries servers?

1023

How to find the number of rows in db2 tables?

1012

Is ibm db2 free?

961

What is a db2 schema?

1186

What is db2 catalog database?

995

List out the buffer pools in db2

1029

Explain about rct.

1036

What is cursor in dbms?

1016

What do you mean by cursor?

953

List out the data types available.

1102

Why db2 is called db2?

981

What is a dbrm in db2?

976