>Cetin and Chad,
>I get the error:
>cStatus is not unique and must be qualified in both of your solutions.
>
>Perhaps this is because I am using VFP7.0. I am NOT using SQL server. Would that make a difference?
>Thanks,
>John

John,

cStatus apparently exists in both tables, right? You have to qualify it with a table alias. You can use short aliases for the tables as I did in my code to you. In my code, I used im to refer to INMATES and ae to refer to ACCT_EVENTS. So, assuming you want the cStatus field from the INMATES table, you would reference it in the field list as im.cStatus.