Create the Output by mearging 2 tables and taking common column sid from both y

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

1 Answers
2449 Views
I also Faced
E-Mail Answers

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 the difference between session and viewstate?

0 Answers

How to create a permanent cookie?

1 Answers IBM,

What are the built-in objects in asp.net?

0 Answers

I am opening Crystal Report in asp.Net 3.5. Report is opening very well but when I click on Refresh button of Crystal Report then it gives "Missing Parameter values" I also tried property of CR Viewer like crViewer.ReuseParameterValuesOnRefresh = True But it is not working. Plz give me solution.

1 Answers

How do you validate the controls in an ASP .NET page?

3 Answers

What does assemblyinfo.cs file consist of?

2 Answers Accenture, HCL,

Contrast oop and soa. What are tenets of each16. How does the xmlserializer work? What acl permissions does a process using it require?

0 Answers

How can we add an event handler for a ASP.NET function executed on MouseOver for a certain button.

0 Answers Siebel,

what is SAP fullform

161 Answers A3Logics, Amazon, DFD, Federal Mogul, Hol Info, IBM, Infosys, Jai Ganesh, Kesri Metal, Lupin, Microsoft, RPG, SAP Labs, SRS Group, TCS, Videocon,

What is round trip in asp.net?

0 Answers

Given an ASP.NET Web Form called WebFrom1, what class does the WebForm1 class inherit from by default? a) System.Web.Form b) System.Web.GUI.Page c) System.Web.UI.Page d) System.Web.UI.Form

3 Answers Syntax Softtech,

What is deference between asp.net, vb.net, c# & j#

2 Answers

For more ASP.NET Interview Questions Click Here