That worked fine, however, when I set deleted on, and use a view on the table with the deleted records, the deleted records show up in the view. I have a GROUP BY, and ORDER BY clause in the query BTW. Why would deleted records show up?

thanks

>>I have two tables. I need to find and eliminate records in table 2, that are in table 1 using two variables, field 1 and field 2. Any ideas how to do this?
>>
>>thanks
>
>Assuming both fields are character data type and the same in both tables:
>
>delete from Table2 where Field1+Field2 in (select Field1+Field2 from Table1)
>
>Otherwise, you will have to Transform() [or convert] them to character strings. You should also test this on copies of your tables with a subset of the data. It worked for me when I tested it.