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
- 8139 Views
- CTS, I also Faced
- E-Mail Answers
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
What is the role of union all and union
what is the sqlcode -501
How do you select a row using indexes in db2?
What is dbrm? What it contains?
What is syscat in db2?
What is a cursor in programming?
What is a db2 table?
what is a corelated subquerry?
What is check constraint. Explain with example.
What is bind package and plan in db2?
How to retrieve rows from a db2 table in embedded sql?
How to check sequence on a table in db2?
Is db2 a mainframe database?
What is precompiler in db2?
What is null value in db2?
