# 3075 INSERT INTO SELECT Statements Incorrectly Including Deleted Rows

---

I wanted to get a table (EMails) across from the live to the development database again so I could check something out. I set up a session in EDBManager to access both databases, deleted everything from DEV.EMails and ran

INSERT INTO DEV.EMails SELECT * FROM LIVE.EMails

Fine but there were 71 records in mailbox -8 when there should have been 3. Check LIVE.EMails and it only shows 3!

The extra 68 were all records that had been deleted.

To get rid of the ones that shouldn't have been there I had to optimise LIVE.EMails