SELECT                 distinct(dbo.Item.CompanyItemId), dbo.Job.CompanyJobId AS JobID,  dbo.Batch.ReportDate AS BatchDate,
	               dbo.JobNoteEvent.Note as Notes,dbo.Item.UnitOfMeasure AS UOM, dbo.SourceType.CompanySourceTypeId,
                       dbo.Product.CompanyProductId
FROM                   dbo.Batch INNER JOIN
                       dbo.Event ON dbo.Batch.BatchGuid = dbo.Event.BatchGuid INNER JOIN
                       dbo.Job ON dbo.Event.JobGuid = dbo.Job.JobGuid INNER JOIN
                       dbo.ProductionEvent ON dbo.Event.EventGuid = dbo.ProductionEvent.EventGuid INNER JOIN
                       dbo.Item ON dbo.Event.ItemGuid = dbo.Item.ItemGuid INNER JOIN
                       dbo.Source ON dbo.ProductionEvent.SourceGuid = dbo.Source.SourceGuid INNER JOIN
                       dbo.SourceType ON dbo.Source.SourceTypeGuid = dbo.SourceType.SourceTypeGuid LEFT OUTER JOIN
                       dbo.Product ON dbo.ProductionEvent.ProductGuid = dbo.Product.ProductGuid left outer join
      	               dbo.JobNoteEvent on Event.EventGuid = dbo.JobNoteEvent.EventGuid
WHERE                  dbo.job.CompanyJobId = 3505048 and dbo.SourceType.CompanySourceTypeId = 'PR'
ORDER BY               dbo.Job.CompanyJobId, dbo.Item.CompanyItemId

SELECT distinct(dbo.Item.CompanyItemId), dbo.Job.CompanyJobId AS JobID  

quote:

---

Originally posted by snufse

Reading both of your questions it got clear to me. Changing my "Select" to this:

SELECT distinct(dbo.Item.CompanyItemId), dbo.Job.CompanyJobId AS JobID  

gave me this result:

04001 3505048
04101 3505048
05001 3505048

I should be ok. Thank you.

---