Hi Ken, > insert ... select works between tables in a single database. It does not > seem to work between databases. You *should* be able to refer to tables in different databases using the dot notation, e.g. INSERT INTO db2.mytable SELECT * FROM db1.mytable I haven't tried this, but it ought to work. J