Tamar,
What I finally did was include the iOrder field in my output and used a HAVING clause to filter any iOrder that was not .NULL. or 1
Thanks for your help
Rex
>>Tamar,
>>
>>That worked, but I also need to have the UCnCnMet.iOrder to be 1, I only need the first contact record for the patient.
>>
>>Any idea how I can do this?
>>
>>TIA
>>
>>Rex
>
>If you need the filter to be part of the join condition, add it to the ON clause. You do this when you only want to consider records that meet the filter condition for the purpose of deciding which records come in through the regular part of the join and which come in through the outer join part. It sounds like that's what you want here.
>
>Tamar
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