Vijaya,
Better use joins , below is a similar example:
--------------------------------------------------------------
create table class
(
classid int,
classname nvarchar(50)
)
insert into class values(1,'class1')
insert into class values(2,'class2')
insert into class values(3,'class3')
create table subjects
(
subjectid int,
subjectname nvarchar(50)
)
insert into subjects values(1,'Computers')
insert into subjects values(2,'Biology')
insert into subjects values(3,'English')
create table location
(
locationid int,
locationname nvarchar(50)
)
insert into location values(1,'hyderabad')
insert into location values(2,'hytech city')
create table teacher
(
teacherid int,
teachername nvarchar(50),
classid int,
subjectid int,
locationid int
)
insert into teacher values(1,'Ogipansrk',1,1,1)
insert into teacher values(2,'Billgates',2,2,2)
select t.teacherid,t.teachername,c.classname,s.subjectname
from teacher t
inner join class c on t.classid=c.classid
inner join subjects s on t.subjectid=s.subjectid
where t.locationid =1
Regards,
Ogipansrk
Vijayar, if this helps please login to Mark As Answer. | Alert Moderator