I have a table full of client inventory data and there is a lot of duplicate data from older inserts I would like to remove. I have not done very many complex remove statements so I could use some help.
rid (autoincr, id)
What I'm looking to do is just keep records which match the MAX(`date`) for each client_id.
error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where a.date < ( select MAX(b.date) from my_inv_data b where a. client_id = b.' at line 2