title: Is it legitimate to combine INSERT and SELECT statements in SQL?
body: <p>Is it legitimate to use a SELECT and INSERT simultaneously? Suppose we want to move old records from one table to another table with the same columns -- can I do this in a single statement? I feel like it should be possible with a stored procedure and it would be interesting to see how that could be done (from my perspective it would seem easier to manage this sort of thing in a programmatic context.) I'm actually primarily curious about whether it would legitimate to write a statement with both a SELECT from one table and use that information to INSERT into another, and hopefully an example of what that might look like.</p>