title: sql move row from one table into another
body: <p>I know how to do this, but I am not sure if it is wise, so I ask:  I have one table that stores any issues with software that we use at work.  If the problem becomes resolved, should I move that row to a resolved issue table, or should I only insert the issue's table pk, and whenever I query open issues use an outer join?  Just looking for industry standard on this.</p>