I have a multiple back-end databases because we one db just can't hold all of our data. So, we have db1, db2, etc. I would like to just copy all the tables from the specified back end to my new db (dbNew) that I'm creating so that I can access the data to do my analysis. Is there a relatively simple way to do this? I get confused because I'm not sure how to write the SQL statement that references the db1 and dbNew. Or maybe there's a better way?