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
- 3172 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
What are the two properties that are common on every validation control?
I want to connect a system in LAN and I want to access that. Whenever I am moving a mouse in my desktop, the similar thing has to happen in another system in which I have connected. I need coding for this in C# and ASP.NET Can anyone please help me. It is very urgent. Thanks in advance. My email id is manojkumarchallagundla@gmail.com Will you please?
What are session state modes in asp.net?
Can you nest updatepanel within each other?
Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default ?
How do I know asp.net mvc version? : Asp.Net MVC
What is route in web api?
What is asp.net web application?
Define machine.config in .net?
Define web.config in .net?
Describe briefly what is the role of IIS on an ASP.NET application? What does it for the same application?
How to communicate via Remote proxy with Client? a)MarshalByRef b)Marshal by Value or Any thing else?
What is the function of new view engine in asp.net? : asp.net mvc
Describe how passport authentication works.
How do you initiate validation on the server manually? What are two situations when you might you want to do that?
