Copy specific data to another table

I am currently developing an inventory database. The items usually are consigned to a shop and then it's either returned to the head office and it will be consigned again to another shop or it will be sold. Is there a way that I can transfer all the sold items to a new table without fearing that the others will stay on the movement table?

try to use an sql statement similar to the following:

Code:

---

Select * Into SoldItems from MyItems where IsItemSold = 'True'

---