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 ...