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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results