I have a question about old employees, as in my company we have 12 stores and staff is changing rapidly and I have a large list of people in my cashier and salesrep table that dont work here any more. My boss wants me to delete all old employees. Does anyone knows a query to run on Headquarters manager to delete them and what consequences could I have? I was thinking to write a query and send it to the stores with Worksheet style 51 - execute sql command. Is everything ok with this query (x, y, z are old employee numbers that I'll enter manually):
delete from cashier where id in (x, y, z, ...)
delete from salesrep where id in (x, y, z,...)
Does anyone have any other idea or any experience with deleting old employees?
Thanks