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

What is application variable?

0 Answers  

What do you mean by query string?

0 Answers  

Explain the difference between web user control and web custom control?

0 Answers  

How to Convert a String into Float without using any built- in library of .NET String = "1235.45" needs to converted to a float

2 Answers   CA, Microsoft,

What does asax stand for?

0 Answers  

How should I destroy my objects in asp.net?

0 Answers  

What is personalization? What are the properties available in personalization?

1 Answers  

what is strong name?

4 Answers   Fidelity, Infosys, Microsoft, Shriram Value Services,

Define secured sockets layer.

0 Answers  

Name the control which can be used to reserve the space on web page for storing localized data.

3 Answers   IBM,

what is uncle aunty file

1 Answers  

Why do we need master page in asp.net?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories