I'm thinking you want to use a UNION SELECT maybe... It is hard to say without understanding what the tables are being used for and what your intention is. Possibly separate recordsets for each table. I just don't know enough background about how the tables are used and what exactly you are trying to achieve. I can only say that the recordset you are creating is almost certainly not the right way to do it.