I'm afraid I'm going to hear this has no easy answer, but I'll ask: We have EndDate IS NULL for current records and records that have well... ended have a date. So anyway I want to do a search and ...

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