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
- 8847 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 null indicator in cobol db2?
How to rename a table in DB2 ?
Explain packages.
What is the difference between drop table and delete table?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Define declaration generator (dclgen).
What is the result of open cursor statement?
How can you quickly find out the # of rows updated after an update statement?
What is the syntax for FETCH in DB2 ?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is dclgen in db2?
Which isolation level provides maximum concurrency?
How is a typical db2 batch pgm executed?
How do you select a row using indexes in db2?
What is db2 optimizer?
