You can use the temp table, put the only exist records into the temp table then you can delete the original table's records use the condition with the information of the temp table. onestone