Hi,
I want to fetch data from three table of database in which i am getting exception,query which i am using is
select StudentInfoId, RegistrationNo,FirstName,MiddleName,LastName,FathersName,MothersName,DateOfBirth,CurrentClassNo,SectionNo,RollNO,Status,MobileNo,CAddress1,CCity,CZipCode,PAddress2,PCity,PZipCode,FathersOccupation,HouseAllocated,Medium.MediumName,SubjectName,Height,Weight,IdMarks1 from StudentInfo,Medium,Subjects where RegistrationNo='1' and Medium.MediumId=StudentInfo.Medium and StudentInfo.Subjects=Subjects.SubjectId
The Exception is
"Conversion failed when converting the varchar value |2|3| to data type smallint". where
|2|3|
is the data in the field of
StudentInfo.Subjects
.
Here
StudentInfo.Subjects
is of type varchar and
Subjects.SubjectId
is of type
smallint
.
Pls suggest me a way to do same.
Thanks
Abhishek