Paul,
Take a look at the IN clause. You may be able to formulate your query by doing
something like this
Select * from table where pkey not in ;
(select col1, col2, col3 from table group by 2,3)
This should return all records not selected in the 2nd query.
Let me know if that works for you..
Thanks,
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.