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
3006 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 profiles in asp.net

1 Answers

asp.net page is a object or not?

5 Answers

can we remote debug applications with the remote debugger installed with vs.net 2002, with vs.net 2003?

0 Answers

What is the significance of ASP.NET routing?

0 Answers NA,

Explain a program using razor view engine to create a simple application? : asp.net mvc

0 Answers

What is ascx?

0 Answers

Why is global asax is used?

0 Answers

What is the question mark in a url?

0 Answers

What is the Global ASA(X) File?

2 Answers

What is the concept of postback in asp.net?

0 Answers

What does the following SQL statement return, assuming that all tables and column names are correct? SELECT FirstName, StreetAddress FROM Employees JOIN AddressBook ON Employees.EmpID = AddressBook.EmpID a) Nothing, the JOIN syntax is wrong. b) All the records form the Employees table, and only the matching ones form the StreetAddress table. c) All the records from the StreetAddress table and only the matching records form the Employees table. d) Only the matching records from the two tables.

4 Answers Syntax Softtech,

In order to bind the data from a data source to the Repeater control what property is set and what method must you call in your code,?

0 Answers Siebel,

For more ASP.NET Interview Questions Click Here