What is your expected output?

See if this works for you:SELECT

DISTINCT O2.*

FROM

tmpOrders AS O1

INNER JOIN

tmpOrders AS O2

ON O1.RecordID O2.RecordID

AND O1.ProductID = O2.ProductID

AND O1.OrderDate = O2.OrderDate

AND O1.ProductClass = O2.ProductClass

AND O1.ProductType = O2.ProductType

LEFT OUTER JOIN

tmpEvalRecs AS Rec

ON O2.RecordID = Rec.RecordID

WHERE

Rec.RecordID IS NULL