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



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 are the new features added from ASP to ASP.NET?

0 Answers   Amdocs,


What do you understand from custom control?

0 Answers   C DAC, CDAC,


what is the use of asp.net

3 Answers   ABC,


What are the different types of Session state management options available with ASP.NET?

1 Answers  


Which of the following .NET framework supports Web API?

0 Answers  






Which is the best institute to learn Microsoft Technologies and the faculty if you Know?

0 Answers   TCS,


What is %20 in a url?

0 Answers  


What is inheritance and an how it be used, example with an example?

0 Answers   Siebel,


best .net institute in hyderabad

7 Answers  


Explain the life cycle of an ASP .NET page.

2 Answers  


Do ASP.NET forms authentication cookies provide any protection against replay attacks? Do they, for example, include the client's IP address or anything else that would distinguish the real client from an attacker?

1 Answers  


What are the advantages of the code-behind feature?

0 Answers  


Categories