SELECT * FROM mytable mt1 WHERE mt1.ItemCode = 1 AND NOT EXISTS ( SELECT * FROM mytable mt2 WHERE mt1.FldName = mt2.FldName) UNION ALL SELECT * FROM mytable mt1 WHERE mt1.ItemCode = 2 AND NOT EXISTS ( SELECT * FROM mytable mt2 WHERE mt1.FldName = mt2.FldName)