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?
- 3 Answers
- 8206 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsha
One can use Inner Join to get data from two tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / siri
1)select ssn from b;
2)select b1.ssn from a a1,b b1 where a1.ssn=b1.ssn
3)seelct b1.ssn from a a inner join b b1 on a1.ssn=b1.ssn
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the usage of open cursor command?
what is parm utility
What is load utility in db2?
List out the data types available.
What are the three lock types?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is meant by explain?
What is difference between isnull and coalesce?
Give the COBOL definition of a VARCHAR field.
What are the three types of page locks that can be held?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What is the difference between drop table and delete table?
COBOL 
