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 can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How do I copy a table in db2?
What is data manager?
What is release/acquire in bind?
what is diffrence b/w file-aid tool and file-aid utility???
How do I add a column in db2?
Explain in detail about buffer manager and its functionalities?
Explain various types of locks in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What are the contents of a dclmgen?
Can we delete records from view?
What is blu acceleration in db2?
How can we read records for specific member in CL? AND rpg?
Name the various locking levels available?
i want to maintain uniqueness on pdf without make lf??????????