>select * from part_file where part_pk in (select part_pk from part_used >where used_date !> '20100101' and used_date < '20100101') >>
SELECT pf.* FROM part_file pf ; INNER JOIN part_used pu ON pu.part_pk = pf.park_used AND pu.used_date < '20100101' WHERE pf.part_pk NOT IN (SELECT part_pk FROM park_used WHERE used_date > '20100101')