Here is another method:

create table #Orders (

OrderNum int,

LineNum int,

Product varchar(10),

Result varchar(25)

)

;

insert into #Orders

select 1,1,'ABC',null union all

select 1,2,'XYZ','Requires Review' union all

select 2,1,'Foobar',null union all

select 2,2,'Id10t',null

;

select * from #Orders;

with OrderResults(

OrderNum

) as (

select distinct

OrderNum

from

#Orders

where

Result is not null

)

select

o.OrderNum,

o.LineNum,

o.Product,

o.Result

from

#Orders o

left outer join OrderResults ors

on (o.OrderNum = ors.OrderNum)

where

ors.OrderNum is null;

drop table #Orders;