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

Explain global assembly cache.

0 Answers  

Explain the basic functionality of garbage collector?

0 Answers  

Can we use http handlers to upload a file in asp.net?

2 Answers  

How many Controls present in Asp dot net?

7 Answers   TCS,

When is validation done on the client? How does client-side validation improve the efficiency of an application?

1 Answers  

What are the modes of updation in an updatepanel?

0 Answers  

What r new things introduced in ASP.NET 2.0 in comparision to ASP.NET 1.1

1 Answers  

What is the basic difference between asp and asp.net?

0 Answers  

What is the Difference between Web.config and global.asax? Can we write connection String code in global.asax?

10 Answers   Microsystems,

Differentiate between a hyperlink control and a linkbutton control.

0 Answers  

how many session modes are available?some brief explnation

1 Answers  

What is the answer for "Which configuration Tool your using means" ? we have to tell about IIS or .Net Framework or VSS? Give me in brief ?

3 Answers   eXensys,

For more ASP.NET Interview Questions Click Here
Categories