> For that to work, one first needs to attach one database to the other. > ATTACH command requires a file name. Memory database does not have one.
It's not ":memory:"? >From the docs: http://sqlite.org/lang_attach.html Syntax of the command: ATTACH DATABASE sql-statement ::= ATTACH [DATABASE] database-filename AS database-name