Hi Todd,
>If I understood this correctly, the only way I can see to do it is by using two separate queries and union.
>
>Use the first query to get all the plans for the member. Use the second query to get the clm_amt for each member. Use union to join them in one cursor.
>
>At this point, I say the sql is as complicated as doing it via scan, and for purposes of maintainability I would go with a scan/endscan.

I don't see how the UNION would eliminate the duplicate Clm_Amts, (and I agree the Scan...EndScan seems more maintainable at this point) I just got a couple of ideas from Bret I'm going to try (and comment the heck out of if they work <G>)
Thanks.