Trying To Get The First Count Of A Group Of Rows

Hi, I am trying to get the first row of what might be a group of any size of rows within an id that may contain a specific field. For eg





Row A = NoteID 1, FK_JobID 1, UnRead





Row B = NoteID 2, FK_JobID 1, UnRead





Row C = NoteID 3, FK_JobID 1, UnRead





I need the sql to return to just one Job (row) even though the job as 3 UnRead fields. But its returning 3 because its only doing what I'm asking. What I need it to do is just get the one Job (row) where any of the notes = UnRead.





I tried using Top 1, but that will only ever return one row and since I need it to return more than one job (row) it won't work.





Heres my attempt





DECLARE @UserID INT





SET @UserID = 4








SELECT User_Notes.BeenRead, Master_Jobs.By_Who, Master_Jobs.Next_Action, Master_Jobs.Due_Time, Master_Jobs.Due_Date, Master_Jobs.Contact,


Master_Jobs.Job_Title, Master_Jobs.JobID


FROM User_Notes INNER JOIN


Note ON User_Notes.FK_UN_NoteID = Note.NoteID INNER JOIN


Master_Jobs ON Note.FK_JobID = Master_Jobs.JobID





WHERE Note.FK_UserID = User_Notes.FK_UN_UserID AND


BeenRead = 'UnRead'





Thanks in advance