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
How to implement form based authentication in asp.net application?
What is a server farm in iis?
How do you handle server controls?
Do you support digital rights management to protect my videos?
What are user controls?
Explain what are the advantages of asp.net mvc framework? : asp.net mvc
Explain the components of web form in asp.net
What is a server cookie?
What are client activated objects?
If you want to write your own dot net language, what steps you will you take care?
How to set the pane area to transparent of a scrollPane component.?
What is the difference between globalization and localization?
What is recordset asp?
Is asp.net a programming language or framework?
What does a switch do?