[sqlite] How do you combine two SQLite databases?

[Neil McLeod]

Hello,

I have two SQLite database files, stuff1.db and stuff2.db. Each has three
tables within. I want to combine the two so I have one database file,
stuff.db, with 6 tables. How could I combine the databases? I am aware of
the "attach" command, but this just seemed to create a file with two
sub-databases, each of which has its own tables. (Maybe I used it wrong.) Is
there a specific solution?

Thanks!