SELECT DIST PolicyID FROM Policy ; WHERE PolicyDate <= {2003/12/31} AND PolicyID NOT IN ( ; SELECT DIST PolicyID FROM Policy ; WHERE PolicyDate > {2003/12/31})>I have a policy table with 2 years worth of data. Each record is either a year 2003 or 2004 record. I need to know which policy does not have a 2004 record. I remember seeing something about using two selects with a "Not IN ( select ......)" clause.