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?
Answer Posted / harsha
One can use Inner Join to get data from two tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How would the varchar column remarks defined?
What is the difference between bind and rebind in db2?
What is the meaning concurrency in the db2 database?
Explain about rct in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What are db2 objects?
How can we read records for specific member in CL? AND rpg?
Highlight all the advantages that are attached to a package.
define clustering index.
What is the use of predicate?
What are the benefits of using the db2 database?
How connect db2 database to datastage?
Why db2 is called db2?
How can deadlocks be resolved?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE