Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- RESULT <-- PROJECT<STUDENT.FirstName, STUDENT.LastName, STAFF.FirstName,
- STAFF.INCIDENT.LastName, INCIDENT.DateTimeReported,
- INCIDENT.NatureOfIllness(SELECTINCIDENT.DecisionMade =
- ''(Staff RIGHT JOIN<STAFF.StaffID = INCIDENT.StaffID>
- (INCIDENT LEFT JOIN<INCIDENT.StudentID = STUDENT.StudentID>(STUDENT))))
- SELECT
- s.FirstName, s.LastName, st.FirstName, st.LastName
- , i.DateTimeReported, i.NatureOfIllness
- FROM Student s
- RIGHT JOIN Incident i ON s.StudentID = i.StudentID
- LEFT JOIN Staff st ON st.StaffID = i.StaffID
- WHERE i.DecisionMade = ''
- RESULT <---
- PROJECT <STUDENT.FirstName, STUDENT.LastName,
- STAFF.FirstName, STAFF.LastName,
- INCIDENT.DateTimeReported, INCIDENT.NatureOfIllness>
- (SELECT <INCIDENT.DecisionMade = ''>
- ((STUDENT RIGHT JOIN <STUDENT.StudentID = INCIDENT.StudentID> INCIDENT)
- LEFT JOIN <INCIDENT.StaffID = STAFF.StaffID> STAFF)
- SELECT s.FirstName, s.LastName, st.FirstName, st.LastName, i.DateTimeReported, i.NatureOfIllness
- FROM Incident i
- LEFT JOIN Student s ON s.StudentID = i.StudentID
- LEFT JOIN Staff st ON st.StaffID = i.StaffID
- WHERE i.DecisionMade = ''
Add Comment
Please, Sign In to add comment