SELECT * FROM Students AS Std INNER JOIN StudentSuspensions AS Sus ON Std.StudentID = Sus.StudentID WHERE Sus.EndDt IS NOT NULL That would not work because not ALL students have had suspensions. So ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results