Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

How would the varchar column remarks defined?

1036


What is the difference between bind and rebind in db2?

1393


What is the meaning concurrency in the db2 database?

1056


Explain about rct in db2?

1044


How can record locking be achieved in those DB2 versions which do not support it?

1019


What are db2 objects?

1000


How can we read records for specific member in CL? AND rpg?

644


Highlight all the advantages that are attached to a package.

1072


define clustering index.

978


What is the use of predicate?

983


What are the benefits of using the db2 database?

1154


How connect db2 database to datastage?

1187


Why db2 is called db2?

970


How can deadlocks be resolved?

889


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

2006