Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8666 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 |
Explain about rct in db2?
What is ALTER ?
What is the purpose of rollback and commit?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What is plan in cobol db2?
What are the various locking levels available?
How many sub queries can you combine together ?
What is a predicate?
How to handle null values in db2
What is db2 stogroup?
what are the SQL codes u freequently got?
How do you select a row using indexes in db2?
COBOL 
