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
3171 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

If you are using two select queries and retrieving data. how do you access second query's result set using data reader?

1 Answers Cap Gemini, Keane India Ltd, MindSquare,

In which event of the page life cycle, is the viewstate available?

0 Answers

What is a Windows Service and how does its lifecycle differ from a "standard" EXE?

2 Answers

Name the method that needs to be invoked on the dataadapter control to fill the generated dataset with data?

0 Answers

What are the namespaces used in asp.net mvc? : asp.net mvc

0 Answers

What is microsoft windows sharepoint services?

0 Answers

when u enter the data in one text box once u completed entering the text box data then one page has to be popuped and the text has to be displayed in the parent page

1 Answers

How to reduce the width of textbox in editcommandcolumn of datagrid?

0 Answers

What are asynchronous callbacks?

0 Answers Accenture,

What layout mode is the default when a new Web Form is created? a) GridBagLayout b) GridLayout c) FlowLayout d) FormLayout

2 Answers Syntax Softtech,

How can you pass multiple complex types in Web API?

0 Answers

Tell About Global.asax ?

3 Answers Keane India Ltd,

For more ASP.NET Interview Questions Click Here