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
- 7490 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 responsibility of the construction superintendent
What is the difference between drop table and delete table?
can all users have the privilage to use the sql statement select * (dml)?
What r the comman abends in db2, jcl and cobol???????
What is host variable in db2 cobol?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is package in db2 mainframe?
Give the name of some fields form sqlca.
What is database manager in db2?
What is dbrm library?
Is db2 free?
How can you find out the # of rows updated after an update statement?
What is copy pending and check pending in db2?
How do you eliminate duplicate values in db2?
List out the data types available.
