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
- 7494 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is db2 plan table?
What is the picture clause of null indicator variable?
What is cursor in dbms?
What is temporal table in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is db2 look?
How can record locking be achieved in those DB2 versions which do not support it?
How to check table size in db2 sap?
What does db2 blu stand for?
What is the information associated with sysibm.syslinks table?
What do you mean by storage group (stogroup)?
What are the different types of base tables?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the use of value function?
