select t1.sid ,t1.sname ,t1.saddress,t2.dno,t2.dname from table1 t1 inne

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

Question Posted / praveen singh

1 Answers
3067 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

Please Help Members By Posting Answers For Below Questions

What is the difference between viewstate and hidden field in asp.net?

1018

Explain different authentication modes in asp.net?

1153

What is the use of session in web application?

938

How do you use viewstate?

983

What is difference between datalist and gridview?

1064

What is xaml? Are xaml file compiled or built on runtime?

957

What is an il?

999

What are the asp.net 2.0 features?

989

What are the main requirements for caching?

1026

Explain the features that make asp.net more used framework? : asp.net mvc

923

When you are running a component within ASP.NET, what process is it running within on Windows XP? Windows 2000? Windows 2003?

1040

What is asp.net file?

1170

Explain parts of assembly?

938

Is it true that a Web service must be written in .NET or not?

1076

What are the asp.net security controls?

1149