Click here to Skip to main content
15,868,141 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
SQL
select D.CertificatesReceived,E.StudentID,(E.First_Name+'.'+Last_Name) as StudentName,M.ExamType,M.AppearofMonthandYear from StudentDetails E join SMDetails D on E.StudentID=D.StudentID Inner join ExamEnter M on M.StudentID=D.StudentID where StudentID='Stud1'


This is my query its working without where StudentID. But I want particular student information.

Please solve my problem.

I need particular studentID='Stud1' details how?
Posted
Updated 14-Dec-11 22:40pm
v2
Comments
Shahriar Iqbal Chowdhury/Galib 15-Dec-11 4:33am    
what is the data type of StudentID?
Hari Krishna Prasad Inakoti 15-Dec-11 4:37am    
varchar(12)
Al Moje 15-Dec-11 4:41am    
Advise you to supply the alias of StudentID
example: where d.StudentID='Stud1'
Hari Krishna Prasad Inakoti 15-Dec-11 4:51am    
Thanq

You should mentioned as
E.studentID='Stud1' not studentID='Stud1'.
Its ambigious as multiple tables involved in query.
I hope above helps.
Satish Dudhatra
 
Share this answer
 
Trying using the below clause in the query :

where E.StudentID='Stud1'
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900