You replied while I was replying. That's exactly what happened. See my reply to John.

Thanks,

Michelle


>John,
>
>That won't necessarily do what she wants, will it? Your record in question could match on custno in the first sub-select, but might match the city of another customer in the second sub-select.
>
>>DELETE FROM table1 WHERE custno in (SELECT custno from table2) AND city in (SELECT city from table2)