>As long as 'Jimmy Jones' has exactly the same Client_Num, Client_SRC, FName, and LName in Ver and Bal, the UNION clause will produce just 1 row in the final table/cursor.
>
>Note: If you actually WANTED to see the rows repeated, you change 'UNION' to 'UNION ALL'.

Ok, cool. I'll try that then when I get a chance. Billing is over for the month, so I don't know when.

Thanks!