Ok, got it to work. I tried Nick's first and it didn't delete anything. Then I tried yours, and it deleted too much. I think the problem was that it didn't know that the custno and city had to be in the _same_ record. So I modified it to:

DELETE FROM table1 WHERE custno+city in (SELECT custno+city from table2)

Bingo!

Thanks both of you!

Michelle


>DELETE FROM table1 WHERE custno in (SELECT custno from table2) AND city in (SELECT city from table2)