Here are two more options:

[font="Courier New"]SELECT DISTINCT

T1.*

FROM

myTable T1

LEFT JOIN myTable T2 ON T1.BatchID = T2.BatchID

AND T2.Status = 'Rework'

WHERE

T2.BatchID IS NULL

SELECT

T1.*

FROM

myTable T1

WHERE

NOT EXISTS (SELECT * FROM myTable T2 WHERE T2.Status = 'Rework' AND T2.BatchID = T1.BatchID)[/font]

The first should outperform the second if your indexing is correct.