>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
Suivant
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