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 Posted / 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 View All Answers
What is the main differences between asp and asp.net?
What are the versions of garbage collection?
What are main return types supported in Web API?
What are the different ways you would consider sending data across pages in ASP (i.e between asp to asp)?
How many types of validation are there?
How can I configure asp.net applications that are running on a remote machine?
What r the asp.net list controls and difference between them?
What is Web API Routing?
What is asp.net? How is it different from asp?
Why should i prefer JSP over asp.net or any other web development language..??
What is the importance of aspnet_isapi.dll, inetinfo.exe andaspnet_wp.exe in the page loading process.
What is server components?
Explain server-side scripting and client-side scripting.
How to make paging concepts in datagrid in ASP.NET?
Explain program to call the js function when the change is being made in the dropdown list made in asp.net mvc? : asp.net mvc