Help in writing SQL query for SQL Server

Question

I have 2 tables with following structures:-

1) Student_Details:-

studentId(pk)
studentName
studentGrade
studentExamStatus

2) Student_Result:-

studentId(fk)
studentRank

The data is inserted in 2nd table only if studentExamStatus is P, otherwise if the studentExamStatus is F there is no record in 2nd table for that student.

I want to write query that will give me all the details of all the students along with rank and if there is no rank blank data or null value is fetched.

I tried with normal join but its only giving me students with rank and not all the students

JNK · Accepted Answer · 2011-04-19 12:03:59Z

3

SELECT sd.*, sr.StudentRank
FROM Student_Details as SD
LEFT OUTER JOIN Student_Result as SR
    ON sd.StudentID = Sr.StudentID

Any student without a record in Student_Result will return NULL for StudentRank.

answered Apr 19, 2011 at 12:03

JNK

65.5k15 gold badges127 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mikael Eriksson · Accepted Answer · 2011-04-19 11:23:13Z

0

You should have a look at how you can use outer joins.

answered Apr 19, 2011 at 11:23

Mikael Eriksson

139k22 gold badges223 silver badges293 bronze badges

Collectives™ on Stack Overflow

Help in writing SQL query for SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related