Delete Query

[hawg9]

I have a set of values in table NPANXX and need to delete records in Table 2 where Field A in NPANXX equals Field B in Table 2.

 

[lespaul]

delete from table2 where FieldB in (select FieldA From NPANXX)



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design