Greetings all,
I need some help in writing and understanding a sql query for the following:
Here is a simplified scenario:
2 Tables:
First Table Name
=============
Failed Subjects
Fields
=========
Name of Student
Date of Test
Name of Subject(failed)
Second Table Name
===============
Master Subjects
Fields
=========
Name of Student
Subject enrolled
I need to have a report that shows -
Date of Test
Name of Student
Subjects Enrolled
Name of Failed Subject
If the student has passed the test for a subject, it should appear as 'Passed!' in the "Name of Failed Subject Field"
Thanks in advance!
Mickey