Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 3004 Views
- I also Faced
- E-Mail Answers
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
How do http sessions work?
What is loop in asp.net?
How can we add an event handler for a ASP.NET function executed on MouseOver for a certain button.
How ViewstateMac works?
What is the difference between custom web user control and a custom web server control?
What is the function used for removing an event listener?
Demonstrate Render and PreRender?
What is the difference between localization and globalization?
Difference between Response.redirect vs server.transfer?
Why would a company use an application service provider?
What can we do with asp.net?
What will happen if the server confugration file and the application confugration file have different values for sassion state ASP.NET?
Where you store Connection string in "Web.Config" file in ASP.NET?
What are the benefits of view state?
Explain server-side scripting?
