>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