Select only filelds of "00" or "UU" which is inprogress and un-delivered

The Second: You said it'll show two entries for same JOB
yes you are right and this is the problem which mentioned by our DBA , but
he overcome it by applying filer to select statement


WHERE     (dbo.Issue.SYSTEM = 1) AND (dbo.Status.Result_code = '00') OR

                      (dbo.Issue.SYSTEM = 1) AND (dbo.Status.Result_code =
'UU') "


This filter is used to select only the last status of the job , so by
applying the above statements you will find only one job in App and admin
panel which is unique and status in inprogress and un-delivered