Update field with data from the same table

I have a table of employees per year, need to replicate most of the employee开发者_开发技巧s within the same table just changing the year to which they relate.

Thanks alot.

Mike Teixeira

---

INSERT INTO EMPLOYEES (<foo..bar>, year) (SELECT <foo..bar>, '2011' FROM EMPLOYEES)