AARGHHH just about sums it up!! :-)

What I'm attempting is to only have the records that exist in the old errors table and matches up with the records in the new errors table to be excluded. For exmple,

In the new errors table I have htc id = 6, 7 and 8. In the old errors table I have htc id 6,7,9,11. The results I'm looking should be 6, 7, 8, 9, 11. All these shoudl be distinct. Right now I'm getting 6,6,7,7,8,9,11.

What about this?

SELECT DISTINCT V_terror.htc_id;
FROM udc2!v_terror LEFT OUTER JOIN udc2!valerrors ;
ON V_terror.htc_id = Valerrors.htc_id