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
- 8839 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 function of logging in the db2 database?
Which catalog tables contain authorization information?
Which transaction use a command thread ?
What is a collection in db2?
What will the FREE command do to a plan?
What is a DB2 bind?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
How do you pull up a query which was previously saved in qmf?
What is the picture clause of the null indicator variable?
What is a predicate?
What information can you find in SYSIBM.SYSLINKS table?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
COBOL 
