Igor Tandetnik wrote:
did you try the really obvious way?create table db2.yourtable(...) insert into db2.yourtable select * from db1.yourtableFor 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.
':MEMORY:' ? -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You.