如何获得特定的学生证? [英] how to get particular studentid?

问题描述

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'

这是我的查询，它的工作没有学生ID.但是我想要特定的学生信息.

请解决我的问题.

我需要特定的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?

推荐答案

您应该提到为
E.studentID ="Stud1''而不是StudentID =" Stud1''.
它与查询中涉及的多个表含糊不清.
希望以上对您有所帮助.
Satish Dudhatra

You should mentioned as
E.studentID=''Stud1'' not studentID=''Stud1''.
Its ambigious as multiple tables involved in query.
I hope above helps.
Satish Dudhatra

在查询中尝试使用以下子句:

其中E.StudentID =''Stud1''

Trying using the below clause in the query :

where E.StudentID=''Stud1''

这篇关于如何获得特定的学生证?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！