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

  1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

Create the Output by mearging 2 tables and taking common
column sid from both you should not use database create
table and data in it Randomly

table 1
sid sname saddress
1 sa ampt
2 na hyd
3 ha hyd

table 2
sid dno dname
1 12 stats
2 23 phy
3 12 stats

OutPUt
sid sname saddress did dname
1 sa ampt 12 stats
2 na hyd 23 phy
3 ha hyd 12 stats

Question Posted / santosh


Create the Output by mearging 2 tables and taking common column sid from both you should not use da..

Answer / praveen singh

select t1.sid ,t1.sname ,t1.saddress,t2.dno,t2.dname
from table1 t1
inner join table2 t2 on t1.sid=t2.sid


Regards,
Praveen Singh
praveen.kumar4u1093@gmail.com

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

Describe state management in asp.net?

0 Answers  

Do session use cookies in asp net?

0 Answers  

Difference between ISQL and OSQL??

1 Answers  

What does setting a control's EnableViewState property to false accomplish?

1 Answers  

If you are using two select queries and retrieving data. how do you access second query's result set using data reader?

1 Answers   Cap Gemini, Keane India Ltd, MindSquare,

Types of caching ?

3 Answers   TCS,

How do you handle server controls?

0 Answers   Cap Gemini,

What is odata in web api?

0 Answers  

How to store a dataset in a viewstate?

3 Answers   IBM,

What are the various authentication mechanisms in ASP.NET ?

1 Answers   Digital GlobalSoft, Satyam,

what is loosely coupled solution? How it can be used?

0 Answers   Siebel,

What does the orientation property do in a menu control?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories