One can use Inner Join to get data from two tables.

I have two tables A and B. Both tables are connected with SSN
number as foreign key. I want to retrieve a column data from B
table. How will you write a query?

Question Posted / harsha

3 Answers
8827 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / harsha

One can use Inner Join to get data from two tables.

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do we specify index to include or not during bind process.

2116

List down the data types in the db2 database.

1107

What is db2 look?

1014

What is view db2?

1061

What is a bind in db2?

1030

What do you mean by rollback?

985

What is database manager in db2?

1007

What is the physical storage length of time data type?

1114

What is db2 bind process?

1231

What is performance tuning db2?

1056

What are the uses of db2 optimizer?

1286

What is meant by explain?

1119

What is the use of runstats in db2?

1097

Mention the location where the output received from explain statement is stored.

1117

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1047