>>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
oops.........sorry about that
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement