The command-line ... SQL INSERT trickery (well, I thought it was tricky the first time I saw it in action). The basic idea is to use the output of a SELECT statement as the input to an INSERT ...

If I were doing this exercise on Windows, I might well use the visual SQL query builder and SQL command line in Alpha Anywhere. The key ... to create and run a query against multiple tables ...