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...

He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?

Answer Posted / sneha.va

Suppose 2 tables;
Employee : having columns
empid,empfirstname,emplastname,MangerID
Manager : ManagerID, Managername

SELECT A.EMPFIRSTNAME,B.MANAGERNAME FROM EMPLOYEE A INNER
JOIN MANAGER B
ON A.MangerID = B.MangerID

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a set of test cases to test youtube?

7729


which sanity testing is performed?

1687


What is the difference between functional requirement and non-functional requirement?

1141


what is e-tester?

2595


Hi I want to start online training couses for testing Any body plz help me out how to start the online courses Plz post the answer here or send me a mail for kommineni.1020@gmail.com

2234


I have interview on Guide wire testing. If you please share me.

876


What is security Hole ? Is this possible Some one can acess any of restricted page (like admin side)? How you test this previllaze?

2421


Hi there Does anybody can respond to my Questions? Is some one there to answer my Questions posted in Software testing category.pls E-mail to sunitht27@yahoo.com

2185


What icon is used in WinRunner to get an explanation of the syntax of TSL?

2088


What is un-installation testing?

1180


Is anybody have the telecom systems test cases from start to end?

2099


what is test case management?explain in brief.

2103


Can you explain equivalence partitioning?

1042


how deployment phase of SDLC differs in product based and in service based company ?

2979


i heard that mainframe testing is diff from other environments & has lot of keyboard input????pl clarify my doubt & let me know in what way its diff??

2122