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
- 8873 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 are the advantages of using a PACKAGE?
How to find the number of rows in db2 tables?
What is ibm db2 client?
How are write I/Os from the buffer pool executed?
What is SPUFI?
Q4. How will you get the count of record without using COUNT verb in query?
What are the three lock types?
What are column-name qualifiers used?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is a host variable?
When is the authorization check on DB2 objects done - at BIND time or run time?
cursor with hold explain ?
COBOL 
