Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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


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 the Impprsonation?and what is the importence of that?

3 Answers   eXensys,

What is a web server? What are the load limits in it?

0 Answers   Wipro,

Where can we set the specific variables for a application and Session objects ?

2 Answers   Siebel,

What is SQL injection?

2 Answers  

AJAX - explain the concept and some controls like update panel, tabcontrol etc

2 Answers   Syntel,

can i call the java script to code behind file?if yes how?

4 Answers   Wipro,

Explain the difference between debug.write and trace.write?

0 Answers  

I’m having some trouble with cas. How can I diagnose my problem?

0 Answers  

What is state management in asp.net with example?

0 Answers  

What is the significance of ASP.NET routing?

0 Answers   NA,

What does clearing cache?

0 Answers  

What is the difference between ExecuteReader,ExecuteNonQuery and ExecuteScalar.

8 Answers  

For more ASP.NET Interview Questions Click Here
Categories