Create the Output by mearging 2 tables and taking common column sid from both y

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 / santosh

1 Answers
3099 Views
I also Faced
E-Mail Answers

Create the Output by mearging 2 tables and taking common column sid from both you should not use da..

Answer / 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

More ASP.NET Interview Questions

What is cookie less session? How it works?

2 Answers TCS,

WHT IS DIFFERENCES BETWEEN HTML CONTROLS AND SERVER CONTROLS.

11 Answers HCL, Microsoft,

step to create a strong name?

1 Answers

What is the difference between Proxy and Contract?

1 Answers

In this case if exception occure in Database which catch block will be exexcuted?

1 Answers Microsoft,

Give a few examples of page life cycle events.

0 Answers Accenture,

How can you dynamically add user controls to a page?

0 Answers

What are the 3 types of web?

0 Answers

i have a register form & in that form i have a 2 textboxes for entering name&age.my doubt is that how can i provide error message like "invalid entry" when user enter a invalid name/age(eg:user enter name as #%%%##daff,and age as 1000.)in that textboxes.I want code.

3 Answers

What is the difference between ldap and active directory?

0 Answers

Explain the difference between overriding and overloading?

0 Answers

What is a gridview in asp.net?

0 Answers

For more ASP.NET Interview Questions Click Here