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
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 |
What are the new features added from ASP to ASP.NET?
What do you understand from custom control?
what is the use of asp.net
What are the different types of Session state management options available with ASP.NET?
Which of the following .NET framework supports Web API?
Which is the best institute to learn Microsoft Technologies and the faculty if you Know?
What is %20 in a url?
What is inheritance and an how it be used, example with an example?
best .net institute in hyderabad
Explain the life cycle of an ASP .NET page.
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?
What are the advantages of the code-behind feature?