Trying To Select Info With If Exists Statement With No Avail

Im trying to select rows on the following criteria





My app has a user that can have x jobs, each job has related entries which are marked has unread or read. I need to return any jobs that contain any unread entries also I need to return other jobs that have no entries marked as read.





I am able to return the following:








Comment UnReadMy Job 164


Comment UnReadFor Cam 166





Comment ReadThe Job 157


Comment ReadThird 159


Comment ReadMy Job 164


On Site Visit ReadMy newest job for log test 167





but as you can see jobid 164 appears in both groups and I need it to be one or the other





I tried using the if exists statement and was only able to return one group either unread or read, not both. I've tried everything but I'm new and I figure that theres got to be a more elegant way. Heres my sql:








CREATE PROCEDURE spGetJobsByUnreadAndReadByUserID


@UserID INT


AS








BEGIN


IF EXISTS(SELECT DISTINCT Master_Jobs.JobID, Profiles.ProfileDescriptor, Backup_UserNotes.BackUp_Read, Master_Jobs.Job_Title, Master_Jobs.Contact,


Master_Jobs.Due_Date, Master_Jobs.Due_Time, Master_Jobs.Next_Action, Master_Jobs.By_Who





FROM Master_Jobs INNER JOIN


Note ON Master_Jobs.JobID = Note.FK_JobID INNER JOIN


Backup_UserNotes ON Note.NoteID = Backup_UserNotes.BackUp_NoteID INNER JOIN


User_Notes ON Note.NoteID = User_Notes.FK_UN_NoteID INNER JOIN


Job_Assignments ON Master_Jobs.JobID = Job_Assignments.FK_Master_JobID INNER JOIN


Profiles ON Master_Jobs.FK_ProfileID = Profiles.ProfileID INNER JOIN


Users ON Backup_UserNotes.BackUp_UserID = Users.UserID AND User_Notes.FK_UN_UserID = Users.UserID AND


Job_Assignments.UserID = Users.UserID





WHERE Users.UserID = @UserID AND-- Note.FK_UserID = User_Notes.FK_UN_UserID AND


BackUp_Read = 'UnRead')








BEGIN


SELECT DISTINCT Master_Jobs.JobID, Profiles.ProfileDescriptor, Backup_UserNotes.BackUp_Read, Master_Jobs.Job_Title, Master_Jobs.Contact,


Master_Jobs.Due_Date, Master_Jobs.Due_Time, Master_Jobs.Next_Action, Master_Jobs.By_Who





FROM Master_Jobs INNER JOIN


Note ON Master_Jobs.JobID = Note.FK_JobID INNER JOIN


Backup_UserNotes ON Note.NoteID = Backup_UserNotes.BackUp_NoteID INNER JOIN


User_Notes ON Note.NoteID = User_Notes.FK_UN_NoteID INNER JOIN


Job_Assignments ON Master_Jobs.JobID = Job_Assignments.FK_Master_JobID INNER JOIN


Profiles ON Master_Jobs.FK_ProfileID = Profiles.ProfileID INNER JOIN


Users ON Backup_UserNotes.BackUp_UserID = Users.UserID AND User_Notes.FK_UN_UserID = Users.UserID AND


Job_Assignments.UserID = Users.UserID





WHERE Users.UserID = @UserID AND-- Note.FK_UserID = User_Notes.FK_UN_UserID AND


BackUp_Read = 'UnRead'





ORDER BY BackUp_Read ASC


END





ELSE





BEGIN








SELECT DISTINCT Master_Jobs.JobID, Profiles.ProfileDescriptor, Backup_UserNotes.BackUp_Read, Master_Jobs.Job_Title, Master_Jobs.Contact,


Master_Jobs.Due_Date, Master_Jobs.Due_Time, Master_Jobs.Next_Action, Master_Jobs.By_Who





FROM Master_Jobs INNER JOIN


Note ON Master_Jobs.JobID = Note.FK_JobID INNER JOIN


Backup_UserNotes ON Note.NoteID = Backup_UserNotes.BackUp_NoteID INNER JOIN


User_Notes ON Note.NoteID = User_Notes.FK_UN_NoteID INNER JOIN


Job_Assignments ON Master_Jobs.JobID = Job_Assignments.FK_Master_JobID INNER JOIN


Profiles ON Master_Jobs.FK_ProfileID = Profiles.ProfileID INNER JOIN


Users ON Backup_UserNotes.BackUp_UserID = Users.UserID AND User_Notes.FK_UN_UserID = Users.UserID AND


Job_Assignments.UserID = Users.UserID





WHERE Users.UserID = @UserID AND-- Note.FK_UserID = User_Notes.FK_UN_UserID AND


BackUp_Read = 'Read'





ORDER BY BackUp_Read ASC


END


END


GO








Thanks again