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

Let's say I have an existing application written using vb6 and this application utilizes windows 2000 com+ transaction services. How would you approach migrating this application to.net?

0 Answers

What is server side session management?

0 Answers

How can we create pie chart in asp.net?

0 Answers

what is Master pages in asp.net? what is the advantages and disadvantages?

3 Answers

Why is validation always done on the server? When does that occur?

2 Answers

Can i have both C# and vb.net code in same assembly?how?

5 Answers Wipro,

What is advantage of asp.net?