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